I have 188 excel tables that I wish to merge into a single spreadsheet. Tables are all formatted the same. I know that I can copy and paste them individually to a spreadsheet but I am looking for an easier method
you can use power query or use a formula like: =VSTACK(Sheet1!A1:ZZ1, Sheet1:Sheet188!A2:ZZ999) of course adjust the sheet names and range accordingly and I'm assuming the header is the same on each so I take it from 1 sheet and start on row 2 on the rest. Once done you can Copy and then Paste as Values if you want to delete the original sheets.