Generating calculation sheets whenever new sheets are automatically created

[CV12]

Hi, might have a real complex question here:

My calculation software generates 5 export sheets containing details. For those export sheets i have one calculation sheet that makes results of those calculations.

So i have 'EXPORT1' To 'EXPORT5' that are created automatically. Sheet 1 uses the results of those sheets. Now i also want to have the results of 'EXPORT11' to 'EXPORT15', 21-25, 31-35, 41-45, 51-55 and so on. Is there any way to mass copy sheet 1 so that it uses the results of the upcoming EXPORT sheets?

Sheet 1 is created by me and is always the same. The only thing that needs to be changed is that it uses all the results from EXPORT1-5 to EXPORT11-15 and so on... I want to have a lot of duplicates so doing this manually costs a lot of time. Any way to do this?

Thanks in advance.

 

[COwen]

Can you share a sample of your data and what you're trying to achieve?

 

[CV12]

I use 'EXPORT1 to 5' for the results on my first sheet. Now i want to copy this sheet with the same formulas, but 'EXPORT1 to 5' should be changed to 'EXPORT11 to 15' and so on. So i just want to copy this sheet with a fixed addition in the '!EXPORTX'

I want to do this automatically because my software program may generate 250 EXPORT sheets which are 50 copy pastes.

 

[CV12]

I want to use this table on the original sheet that is made by me. In the formulas i refer to this table so it knows to use the results from those sheets. So i want to duplicate this sheet (many times) and add +10 to every EXPORT every time a duplicate is made. Hope i'm clear enough

Thanks