See one possible answer to your first posting of this question.

--
Regards,
Tom Ogilvy

"Jade" wrote in message
...

We have a spreadsheet that has worksheets names 06180 to 06189. I want to
create a summary worksheet of some of the data. The worksheets are
identical
and the data that I want will always be the same.

The worksheets are named 06180 to 06189.

Date (H7)
Supplier (B8)
Purchase Order Number (H9)
$ Amount (P40)

I have not used macros or VBA before and I am thinking this is the only
way
to be able to summarise the data that I want.

Also at the end of every month we use a new spreadsheet so how do make it
so
its easy for me to change formulas etc for a new spreadsheet??