Copy and Past Formula to multiple sheet

[ecoleman42us]

I have a formula that references sheet names. I can create the formula that goes into the same cell on each sheet. When I copy and paste the formula the sheet will not automatically up date. Is there way of doing this? I created a separate sheet and listed the names of all the other sheets being used thinking I could use an indirect formula but again when I copy and paste the sheet name did not update. The sheet names are in sequence 1st,2nd,3rd.....

 

[metfast]

 

[ecoleman42us]

Thanks but I guess I need to better explain what I am trying to accomplish.
Sheet1 (1st) cell B3 has data
Sheet2 (2nd) cell B3 ='1st'!B3
Sheet3 (3rd) cell B3 = '2nd'!B3
This can go on for 60+ sheets. As of now if I copy and past the sheet 2 formula to any other sheets the formula contains sheet 1 or '1st'. I want to be able to copy the formula from sheet 2 and paste it to all the additional sheets automatically updating the sheet names.
I am not sure if this is possible with a simple excel command, VBA code or if it is even possible.

 

[ecoleman42us]

Thanks but I guess I need to better explain what I am trying to accomplish.
Sheet1 (1st) cell B3 has data
Sheet2 (2nd) cell B3 ='1st'!B3
Sheet3 (3rd) cell B3 = '2nd'!B3
This can go on for 60+ sheets. As of now if I copy and past the sheet 2 formula to any other sheets the formula contains sheet 1 or '1st'. I want to be able to copy the formula from sheet 2 and paste it to all the additional sheets automatically updating the sheet names.
I am not sure if this is possible with a simple excel command, VBA code or if it is even possible.

I ended up hiding sheet names in a cell then used an indirect command to dynamically update the formula.