Merge 500+ Tabs into one list

[jordsh7]

Hi, I was wondering if there is anyway of being able to merge 500+ tabs to create one list. Power Query can not handle the data as it is taking far too long for it to process. I have seen people create macros for merging on multiple excel sheets so im hoping this can be done for tabs?

Each tab has the same column headings

Thanks in advance

 

[skillilea]

Post a sample of the data. Ideally use XL2BB so we can manipulate and copy the data into excel.

Also, what are the tab names. Do they have some kind of sequence or is it every sheet in the workbook?

 

[Dave Patton]

• put a blank sheet named Start before the relevant sheets
• put a blank sheet named End after the relevant sheets
• put the relevant range in the formula to include your information

Try the following formula =VSTACK(Start:End!A2:M20)

You could test with a small number of sheets.

 

[jordsh7]

Amazing! That worked perfectly. Massive help thank you!!

 

[Dave Patton]

Thanks for the feedback.