Need help with copying rows, replicating sheets, naming sheets and assigning print area...

Hi Friends...

I am making a budget file and need your help....

I have structured the file with a Variable Sheet, Summary Sheet and a 100 - Project Leader (which is actually the master sheet)....

I will be working on some variables which will keep altering the layout of the file in terms of number of rows....

I am attaching the file and have written (on the variable sheet) the areas where I need help.

Looking forward to help as I have been badly stuck with this one and need to finish it urgently.... This is the basic file yet.... I have to incorporate other things based on this file.... Hence, I am stuck until I finish this one

Please revert...

Many thanks... always....