Hi,

I am using Excel 2002 and work on a workbook.

Inside the workbook, there are 3 sheets: Sheet 1, Sheet 2, Sheet3

For each of the sheet, Cell A1 and A3 (two cells) both contain the data
that I want.

Question:
I want to have Sheet 1: Cell A1 and A3, Sheet 2: Cell A1 and A3, Sheet
3: A1 and A3 data shown on a new sheet, say Sheet 4.

1)
Is there an automatic way that all these 3 sheets can be "exported" to
Sheet 4?

2)
Any other method than marking " = Sheet1!A1 " etc in Sheet 4?

Thanks.