Dear Forum,

Is it possible to take data from multiple worksheets and reflect it into one worksheet?
My research is all pointing me to using the 'Data Consolidation' and/or 'Pivot Tables' function in Excel,
However, I do not want the sum, average nor count of the data I consolidate.

I simply want the data from Worksheet 1, 2, 3, 4, 5 to appear (as they are) in Worksheet 6.
Worksheet 1, 2, 3, 4, 5 includes data individually entered by Sales Managers of different locations,
Each time there is a change/addition to the data, I want it to appear dynamically on Worksheet 6.

Is this possible?
Would really appreciate it if someone could kindly point me in the right way!

Thank you very much.