Referencing worksheets

[note]

Greetings,

I have 52 worksheets, (week 1 - week 52), each is basically a timesheet
for multiple and variable staff members.
There are various calculation with regard to hours worked, tax, one each
of the worksheets.

I have another worksheet on which I wish to reference each of these
worksheet to extract a total for each week.

Q1: How do I reference each worksheet (week 1 etc) without having to
enter week 1!A35+ week 2!A35 etc?

Q2: How do I get a cell value from a worksheet into a Word document.
specifically Cell c25 and j42?

I have another worksheet which I want to add some more calculations on.
These are based on a Thursday to Wednesday payment.

Q3: Is there a simple way to use a formulae which I just type in a week
number (based on the Thursday pay date) which in
turn goes to the two week 1 & week 2 (or week 2 and week 3)etc then
puts the data in the new worksheet?

Ref Q2, I have named the cells, but I can never see them in Word.

Using Office 2000

Thanks in advance

Kevin

 

[Don Guillett]

try this where first is the first worksheet and last is the last worksheet
name
=sum(first:last!a1)
to get the total of all worksheets for cell a1

 

[note]

Thanks Don ,

That worked a treat.

Regards Kevin

 

[Don Guillett]

Please keep all questions in the ng unless invited to send to a personal
address. This way all may benefit from the questions/answers.

name a worksheet first and name a worksheet as last>put all others you want
to sum in between these>use the formula given.

You can create a template worksheet and whenever you want to add another
just right click on the sheet tab>copy>rename. Or, you may create a macro to
do 4 or 52 at once.

However, why not just use ONE worksheet and then use
data>filter>autofilter or advanced filter to select dates desired.

Don,
Thanks for the answer it worked a treat.

Can I be cheeky and ask one more thing of you....

How do I make it conditional, for example how do I wrap it up in an if
statement for the week 23 week 24 etc when they do not already exist.

I am currently creating the worksheets as required (month at a time,
create worksheet and copy last months basic form over to it (x 4
).)..... Is there a way of creating 52 identical worksheets with
formulae's and formatting etc all in one swoop?

Totally new to excel, trying to help my son get his business accounts
working a little better than they have been. He keep losing track of
stuff.

Regards

Kevin