Referring to other sheets within a workbook

[Arsie]

This is driving me barmy. Any help would be great.

I have list of formulae in cells a1:a50 in a sheet to pick up from specific
cells in other worksheets called week01 to week50

Something like this :---
Column A Column B
Row 1 Week01 week01!a1
Row 2 Week02 week02a1

etc

Is there a formula or function I can use in b1:b50 that will pick up the
words "Week01" etc and add that to the cell reference "a1" so that I don't
have to type every sheet name and the data appears automatically.


Hope this makes sense!


Thanks

Arsie

 

[Andy B]

Try using INDIRECT

Your formula in B1 would be:
=INDIRECT(A1&"!A1")

Andy

 

[Arsie]

Absolutely stunning.

Thanks a lot.

Arsiep

Try using INDIRECT

Your formula in B1 would be:
=INDIRECT(A1&"!A1")

Andy