I have a folder with several workbooks (one per worker) with several identical sheets (one for each 30 day period) created by a macro.

I have a power query query to pull several of these sheets to create a summary pivot by month.
My problem is that the first sheet pulls in the way I expect it to, but all subsequent sheets are offset by by a column, as if column "A" which is an index column has been removed.
So when I go to consolidate the data, it is no longer aligned.

I have double checked the sheets and they are identical. I have removed any merged cells, but that doesn't seem to be affecting it.

Any ideas for how to get the data aligned so it pulls into the power query editor like it looks on the worksheet?

Thanks!