Putting data from multiple worksheets into one

[Teffy]

The treasurer of a local non-profit organization sends me a workbook
each month containing worksheets for each bank deposit. I want to put
all of the data into one Excel 2000 worksheet to use for monthly
membership mailings.

Each worksheet contains three sections: header, data, sums. The header
looks like this:
------------------------------------

MY NON-PROFIT ORGANIZATION NAME
INCOME FOR JULY 2005
DEPOSIT DATE: 7/13/05
FIRST_NAME LAST_NAME STREET/CITY/STATE/ZIP GIFT M'SHIP TOTAL

---------------------------------------
The data rows are as you might expect:

***************************
firstname1 lastname1 street/city1 gift_amt1 m'ship_amt1 total1
firstname2 lastname2 street/city2 gift_amt2 m'ship_amt2 total2
etc.
***************************
Each worksheet may have a different number of data rows.

The 'sums' row contains formulas like =SUM(M5:M40) for some of the
columns.

How can I end up with one worksheet containing all data for the month?
i.e.:

HEADER
data for week 1
data for week 2
data for week 3
data for week 4

I don't really care about the 'sums' data.

Thanks so much,
Teffy

 

[Ron de Bruin]

Hi Teffy

Try this
http://www.rondebruin.nl/copy2.htm

 

[Teffy]

Dear Ron de Bruin,

I am very grateful to you for your instructions! Now I am able to do
exactly what I wanted! And, you have given me the start I needed to
record a macro; adding even more to the capability!

Thank you so much.
Teffy

 

[Ron de Bruin]

You are welcome