Hi,

I am creating a workbook, where I will need to see, in different sheets, the outputs that will be arrived at by different inputs. So there are say 10 input sheets, all have to undergo the same calculation to arrive at the output, but the input sheet values of course will be different. The Catch here is that I do not know the number of these input sheets.
I already have a macro in my workbook which creates a certain number of "Input" sheets (depending on a cell value).
In order to tackle with this, I thought of:
1.) creating a sample/Master Input and Output sheet. The output sheet would be linked to the Input sheet and display exactly the output that I needed from all my output sheets

2.)Create new input sheets depending on the number of them required. These will be formatted exactly as the master input sheet.

3.)I have been trying to come up with a macro that copies the formulae from the master output sheet, and pastes them in each output sheet(which will be created along with input sheets), only changing the sheet reference to the respective input sheet (instead of the master input sheet). But haven't been successful yet

As an example, I plan to name the sheets as :
"input 1" and "output 1" and so on.
So for "output 1" sheet,when I copy the formula from the master output sheet (linked to master input), I just want to change the sheet reference to "input 1" instead of "master input", all else same. Is there any way that can be done?

Thanks A ton in advance,
D