Consolidating data from multiple tabs into one tab

[Sundance_Kid]

Hi,
I have around 15 tabs with anywhere between 10-50 lines of data in each tab. All tabs have the same 5 column headings, formatting is the same.

Is there any quick way to consolidate all 15 tabs into one individual tab apart from copying and pasting?

Thank you.

 

[arthurbr]

You can use Power Query See Combine Data From Multiple Worksheets into a Single Worksheet in Excel

 

[Sundance_Kid]

You can use Power Query See Combine Data From Multiple Worksheets into a Single Worksheet in Excel

Thanks, I am not familiar with Power Query but it looks like the link you shared is for someone like me.
Thanks

 

[arthurbr]

You're welcome. Feel free to come back with any additional queries

 

[Sundance_Kid]

You're welcome. Feel free to come back with any additional queries

Thanks, I have encountered a problem.
I have 15 tabs with data pasted from other sources.
However, it seems for 7 of the tabs the data pasted in is appearing as a named table range, so when I go to consolidate the 15 tabs, it is only showing the 7 tabs with named table ranges.

Is there a way to remove the table range name for the tables on the 7 tabs?

Thanks

 

[Sundance_Kid]

Update, I was able to convert the tables to ranges and that fixed that issue.

Now issue I have is that none of the 15 tabs are appearing when I enter the formula Excel.CurrentWorkbook() - the tables are named like 06Dec23 or 24May24.

 

[alansidman]

Perhaps you could post your workbook to a site like box.net or dropbox.com and we could then see the full issue and provide assistance.