Need help getting multiple sheets pulled into a single report in the correct order
I have three "what if" schedules that I'm trying to pull into a single report. They are simply named Scenario 1, Scenario 2, and Scenario 3. No matter what order I select them, the resulting report has #3 in first position, #1 in second, and #2 in last.
I did a bulky workaround by adding a Helper Column in each sheet numbering the desired rows so that they would appear in order when I did a Sort; but there must be a better way.
By the way, I tried adding one sheet at a time, save, and run report; hoping that the next sheet added would appear below the previous sheet names, and so on, but that didn't work.
Your suggestion are greatly appreciated. I can see this is going to be an ongoing function that I'll need to conquer.