Merging multiple sheets

[Jim Matthews]

Greetings all:

This may be a simple question, but I have not been able to figure out how to
do it.

I have a workbook with 5-7 sheets and I want to copy all the individual
sheets onto one combined sheet. Is there an easy way to do this?

So far my resident Excel expert has only been able to suggest inserting and
opening a new sheet, then setting up formulas on the new sheet like

='sheet1'!A1
='sheet1'!A1

 

[Burt]

What do you mean by "to copy all the individual
sheets onto one combined sheet" ?

you have 2 sheets and you want to copy both to sheet3.
How will this be possible?

For example:
Sheet1 Sheet2
A B A B
10 20 30 40

if you copy sheet1 A1 result will be 10, if you copy sheet2 A1 result will
be 30
How will you combine these?

Burçin SARIHAN