I have been exploring ways to combine the 8 sheets in the attached file.
I have tried Power Query and there are too many steps involved and not sure how I can easily change the data source.
I am now looking for code to combine the sheets to one consolidated sheet and I would be doing this on a recurring basis.
There is extraneous data outside of the table (top and bottom) and not so sure how VBA code can be used to only combine what is inside the tables. To facilitate any coding, I can say that the tables start at row 7 for each separate sheet (meaning rows 1-6 for each sheet are not needed).
Column names are the same for each sheet
grateful for your help.