Can you please try to create some sample data in new workbooks to demonstrate your operations?
You can attached the sample workbooks in this topic or send them to us via firstname.lastname@example.org.
Please try to be more specific about the operation and the result you want to get.
Thanks in advance.
I have three worksheets with the same headers but those headers are in different orders. I would like to combine them into a single worksheet without re-arranging dozens of columns. The consolidate tool as I have used it, stacks the worksheet information without regard to column header matching