How does report display information from the sheets?
Does anyone know how this work?
I am extracting report from 5 sheets, let's say, Sheet A, B, C, D and E.
In the report, I couldn't understand how the data is being displayed (the sequence).
Before any sorting, the information are displayed randomly, for example Sheet C, D, B, A, E.
Does anyone has any idea, how does this work? Does report extract data randomly? Is there a pattern?
I would like to display the information according to Sheet, A, B, C, D and E (of course the sheet name is not alphabetical order as illustrated for example here).
Kindly advice. Thanks.