Multiple Work Books with Multiple Sheets into different Power Queries|Power Query|Excel Forum|My Online Training Hub

I have 10 workbooks that each contain the following sheets: Yearly total and each month of the year

I have successfully used PQ to total the Yearly and April from each of the ten work sheets but when I go to move onto May and I want to switch to the next table name (all Mays are names the same Table 719, June shares its table name with all ten workbooks etc) it gives me the same query or an error when I try to change the table name in the sample. I don't know how to change the table names so in my new summary work book the tabs for the sheets have a Dashboard, a data tab, Yearly total and a tab for each month. I am stuck. I can find lots of videos to get the summary but none on how to keep using the query to get different data summed. 

Please help! I am on a deadline and I can't create the dashboard without the monthly data. 

Thanks!