Need help with indirect comand

How to refer this Formula to another Sheet for Example "14" ,:"=IF(IF(OFFSET(INDIRECT(ADDRESS(MATCH($AA$2;$E:$E;0);5));0;-1)="Diam.";IFERROR(MID(OFFSET(INDIRECT(ADDRESS(MATCH($AA$2;$E:$E;0);5));$Z4;AB$1);MATCH(TRUE;ISNUMBER(1*MID(OFFSET(INDIRECT(ADDRESS(MATCH($AA$2;$E:$E;0);5));$Z4;AB$1);ROW($1:$901);1));0);COUNT(1*MID(OFFSET(INDIRECT(ADDRESS(MATCH($AA$2;$E:$E;0);5));$Z4;AB$1);ROW($1:$901);1)));"");"Error")="0";"";IF(OFFSET(INDIRECT(ADDRESS(MATCH($AA$2;$E:$E;0);5));0;-1)="Diam.";IFERROR(MID(OFFSET(INDIRECT(ADDRESS(MATCH($AA$2;$E:$E;0);5));$Z4;AB$1);MATCH(TRUE;ISNUMBER(1*MID(OFFSET(INDIRECT(ADDRESS(MATCH($AA$2;$E:$E;0);5));$Z4;AB$1);ROW($1:$901);1));0);COUNT(1*MID(OFFSET(INDIRECT(ADDRESS(MATCH($AA$2;$E:$E;0);5));$Z4;AB$1);ROW($1:$901);1)));"");"Error"))" I want to atach the work book but the size is too big 9 mb , file limit is 1 mb .

I deleteted some sheets some macros , make it good for working

In sheet 12 when I change the Number( diameter 12, 14 , 16 ...) it colect automaticaly the data from left side , So what a want : every diameter should have their own sheet

" Why can't you use the one sheet for them all?"
Because is more usefull ,another way I will scroll from one side to another , there I put put just 2 diameter but in real I have (12.14.16.18.20.22.25.28.32); 9 diameters ,I allready thinking about this, it will take me a lot of time.
About the data : I paste it from another program( Autocad ) that why is so difficult ... so rearrangements are not avaible here ..

In Autocad are maked combinations of cutting rebars ...
This is the best way which I found , but i search a lot of time, I tried a lot of programs including excell , this way is geting me the best result , so it left the last step to do rearrangement of diameter in sheets

Smart !!! But is to much manualy work here , unfortunately is impossible to add more rows , because there is a lisp file which make this , and it make them like a paste them ...
But , PHANKS for IDEA , I will think for another way

Aproximately done !! but , I will finish it !!!
Many phanks from Moldova !!!