How do I merge files into one file

[ghrek]

Hi

I have a folder with 7 workbooks in it.

All workbooks have 3 tabs in them and they are all named the same in each workbook. What im trying to do is merge all the workbooks together into one with all data from each tab.

I.E all data in tab one in the 7 workbooks to be merged into tab one in the new workbook and then repeat for tabs 2 & 3. Any Ideas on a easy way to do it.

 

[sandy666]

try Power Query - From Folder
then merge/append tables suitable