Copying A Link Formula

[Learning VBA]

I am trying to copy a link formula and having some problems.

This is the formula:
='01'!U141

The next few lines I want to look like these:
='02'!U141
='03'!U141
='04'!U141

I can not figure this out. Hope someone has the answer to this

I have about 31 rows and 40 columns that I need to do this with so doing
each one separately would take hours

Thanks in advance

 

[Gord Dibben]

=INDIRECT("0" & (ROW()) & "!U141")

Assumes entry in A1 of Master sheet and copied down.

Will pick up U141 from each of sheets 01, 02, 03 and 04


Gord Dibben MS Excel MVP

 

[Learning VBA]

Thank you so much after a couple of twists it worked perfectly.