Merging sheet data to one spreadsheet?

[HockeyDiablo]

I have a workbook that has 5 similar Sheets worth of data in columns A:U.

Is there a way to create one giant database out of the 5 using VBA? Little out of my element and macro recording ability.

Thank you

 

[alansidman]

You can use Power Query if you have Excel 2010 or later version to append each sheet. No VBA required.