Using cell info to reference worksheet

[n8v_nerd]

Ok, I'm a newbie to this whole excel thing...

What I've got is a 12 month rotation of worksheets (January-December
which contains variouse information. Then, I've got one worksheet(th
first one called Reports) That I want to be able to pull thing
together and summarize them on.

Months Worksheets Setup:
WO# | Location | Name | Date Submitted | Date Completed
Assigned to | Completed By

Now, I have a cell on the Reports worksheet(A2) that I type in th
month I want to lookup.

Now, the thing I can't figure out, is how can I use the value in A2 t
choose which worksheet the formula runs to for its info. I tried:
=COUNT(T(A2)!A:A) ... No dice
=COUNT(A2!A:A) ... Didn't work

I can get the value to pop up into another cell, but just can't get i
to play nice with the path. Any Ideas on how to make this work

 

[Rog]

Sounds like you need to make use of the Indirect function -
check it out in the help file.

Rgds

Rog

 

[JE McGimpsey]

use the indirect function:

=COUNT(INDIRECT(A2 & "!A:A"))