Excel Help.. merging tabs

[Acternaweb]

I have an excel file with a good number of tabs (worksheets). Is there a quick way to merge them to form one worksheet?

Thanks,

[goodroi]

The only way I know is to copy and paste each tab individually. Make sure that all the worksheets will fit on one. Worksheets have a limited number of columns and rows.

[rmplmn]

I am not aware of a function that merges worksheets in Excel. My approach would be to create a new worksheet and combine the important information using the lookup function and array formulas.