Compiling Data from few worksheets to 1 worksheet

[raymond che]

I have 3 different sheets with data that I want to combine into one sheet using a formula. Here is an example:

Sheet A
Date Amount
10/1 $5
10/2 $10
10/7 $5

Sheet B
Date Amount
10/2 $7
10/3 $10

Sheet C
Date Amount
10/5 $5
10/6 $10

I want a fourth sheet that fills with all the data from these three sheets. Ideally it would be in order by date, but I understand that might not be possible. So the last sheet should look like this:

Date Amount
10/1 $5
10/2 $10
10/2 $7
10/3 $10
10/5 $5
10/6 $10
10/7 $5

The reason I want to use a formula of some sort is because if I add more rows to sheet A for example, I want the fourth sheet to automatically add it (whether it's possible to do in date order or not).

Is this possible?

[onroute]

Hi Raymond,

I think you have to use a macro for that sort of sheet data combination.

However, if all you need is the sum of all the amounts in the sheets, can you simply do =SUM(Sheet1!B:B,Sheet2!B:B,Sheet3!B:B), where column B has your amounts?

Cheers

[raymond che]

Any idea using macro to sort it out for this?