Excel for Mac: Combine multiple sheets into one

[yichuansancun]

Hello -

I have a workbook that have multiple sheets. The sheets have the same data structure. How do I combine them into one without doing copy and paste? I tried using consolidate, but consolidate does aggregate on the values. In my case, I don't need to do any aggregation. It is all text. I simple just want all the data to be one the same sheet.

Thanks,
Perri

 

[cyrilbrd]

that worked, thanks!

Most welcome. Thanks for the feedback.