Ok, this is a long query. Well... very confusing!

At work I have a workbook which each worksheet contains details of 1
individual job. So one worksheet = all the labour, rates & material purchases
of 1 job.

So, I created a template which I open upon getting a new job. This is all
fine.

Now I want a summary page within the workbook, which pulls all the
information from the job worksheets.

For instance I'll have

Hours
Current - 1 Month - 2 Month - 3 Month - Previous.

So in the 'current' cell it will have all the info pulled in from the
worksheets and it should automatically seperate into this month, last month,
the month before, before that.

If someone out there knows what the heck I'm trying to say here (I'm crap at
explaining) I'd appreciate ANY help on this matter.

Thanks.

Fairly common. You would need a macro to pull the info in. Much more data
needed. If desired, send your file to my address below along with this msg
and a clear explanation and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"no-one-but-me" wrote in message
...
Ok, this is a long query. Well... very confusing!

At work I have a workbook which each worksheet contains details of 1
individual job. So one worksheet = all the labour, rates & material
purchases
of 1 job.

So, I created a template which I open upon getting a new job. This is all
fine.

Now I want a summary page within the workbook, which pulls all the
information from the job worksheets.

For instance I'll have

Hours
Current - 1 Month - 2 Month - 3 Month - Previous.

So in the 'current' cell it will have all the info pulled in from the
worksheets and it should automatically seperate into this month, last
month,
the month before, before that.

If someone out there knows what the heck I'm trying to say here (I'm crap
at
explaining) I'd appreciate ANY help on this matter.

Thanks.