Hey everyone! I am having a bit of trouble editing an excel sheet to be the way I would like it to be at the end.

Currently, the sheet I am working on has 127 sheets that I want to combine into one table with a few additional columns to get rid of the 127 sheets. I know I can do this using a power query, but I am struggling to figure out how precisely.

These 127 sheets do not start their “tables” always on the same row. They do not have defined tables within these sheets. They do have the same headers for their columns, but the top of each sheet there is a purchase date and a customer’s name that is messing up identifying the table as a table on power query.

What I would like to be able to do is:

- take that information from A1 on each sheet containing the customer’s name and put it into a new column within the table.

- Take the customer since date from B2 and put it into a new column.

- Eliminate the rows above the column headers

- Combine all 127 sheets into one table containing this information into one table

Please help this is insanely over complicated.