Autofill Using Several Sheets

[cchan]

Hi Everyone,

My boss just gave me a painstaking task and I would appreciate any help I could get in making it easier.

On my first sheet I have columns listed Jan Feb Mar ... all the way to Dec

I also have 12 worksheets named Jan Feb, Mar .... Dec

Assuming cell A1 is titled Jan, B1 is Feb, C1 Mar etc

I need A2 to refer to sheet Jan A52, and cell B2 to refer to sheet Feb A52 etc.

Can anyone help with this please?

Thank you!

[benishiryo]

hi cchan, welcome to the forum. try:
=INDIRECT(A1&"!"&"A52")

drag across

[cchan]

This solution does not work for me unfortunately

[cchan]

Jan........... Feb...........Mar Apr
=Jan!$A52 =Feb!$A52
=Jan!$A90 =Feb!$A90

In this type of situation I want to be able to spread across to the right and have the next one be = Mar!$A52 because I have 12 worksheets

Any assistance would be appreciated