formula working in one cell but when copied to another cell it doesn't work

hello all,

cant figure this out, makes no sense why doesn't work....

=IF(ISERROR(INDIRECT("'1'!M4")),"CREATE SHEET 1",INDIRECT("'1'!M4")) in cell b2 on PROPOSAL SCOPE sheet

this formula tells cell to display CREATE SHEET 1 until sheet 1 is created (using macro) and cell m4 on that sheet displays a product number eg 123456 then it changes the CREATE SHEET 1 to that product number. works perfect...

=IFERROR(INDIRECT("'"&ROWS(G$2:G2)&"'!$m$8"),"") in cell g2 on PROPOSAL SCOPE sheet

this formula tells cell g3 on PROPOSAL SCOPE sheet to display cell m8 on sheet 1 after it is created.. works perfect

=IFERROR(INDIRECT("'"&ROWS(H$2:H2)&"'!$k$111"),"") in cell h2 on PROPOSAL SCOPE sheet

this formula also tells cell h2 on PROPOSAL SCOPE sheet to display data from cell k111 on created sheet 1 .. works perfect

=IFERROR(INDIRECT("'"&ROWS(I$2:I2)&"'!$k$109"),"")in cell i2 on PROPOSAL SCOPE sheet

this also tells cell i2 on PROPOSAL SCOPE sheet to display data in cell k109 from created sheet 1 ....works perfect..

Now heres the problem I have 44 lines numbers CREATE SHEET 1 to CREATE SHEET 44 on page where all these formulas do exactly what i need them to, however the second page adjacent to the first also has lines CREATE SHEET 45 to CREATE SHEET 88 and a third page which has the rest up to 100.

when i copy the formula used in CREATE SHEET 1 to 44 to CREATE SHEET 45 to 88 and so on the formulas do not work...for some reason the show just blank cells , no data is being moved from sheets its being asked to move them from...doesn't make sense, same formula, why doesnt it work.


hope u can help...thanks
mike rand