I am trying to collect data from multiple worksheets into one worksheet, generally I can accomplish this using INDEX/MATCH/INDIRECT to create one dynamic formula that can accomplish it. The problem I have now is that on each worksheet all the columns are in a different order. The main problem is that my unique identifier is for each row is in a different position on each sheet. I know a basic solution would be to copy the unique identifier and place it in the first column for each sheet but I need to create a dynamic formula that makes this possible without moving any columns around.


If I need to expand on what I am trying to do let me know and I can.