I just want to clarify the below
-I will not create a data sheet
-The workbook structure is not "6 rows of data on 60 sheets and a summary sheet with about 360 linked cells should present a speed problem."
-The 60 sheet are not always used, in some months only 30 used and in some months i add new sheets, it's just made to serve up to 60 project
I'll try to make it more clear
-It's 60 identical complicated sheets and a summary sheet, each one of the 60 sheet has a 6 rows in the summary sheet
For example, Sheet no. "7" has six rows labeled "7" ( row 38-43) in the Summary sheet, each one of the 6 rows has formulas that summarizes results of sheet "7".
The summary sheet is linked to the 60 sheet through "=INDIRECT" function that uses the row label for defining the sheet no. to read from and uses the column header for as a criteria.
-My work sequence on the old workbook is as the follow
Suppose i have a project with 5 sub projects under it, so this project is 5 lines
In the first 6 rows (labeled"1") i'll paste the 5 line on the data entry area and the 6th row will automatically summarize some data for the project
After that i'll go to sheet no "1" and paste another details for the project and for the 5 sub projects , according sheet "1" will calculate some results based on the pasted data
Then If i went back to the summary sheet i'll find the results summarized in row 38-43
What i need is
1- Make the work book structure only 2 sheet,
2- The first sheet is the Sheet"0" that represent the a template for the 60 sheet
3- The second sheet is the summary sheet with only six rows labeled the same as the template sheet "0"
4- Create a command button in the summary sheet with assigned macros, when the macro runs it will copy the first 6 rows (labeled "0" ) and insert them below and label them 1+ the previous 6 rows label "0+1= 1" and then copy sheet no "0" to a new sheet in the workbook and label it the same as the inserted rows , therefore i'll have sheet no"1" with 6 rows labeled"1" to summarize it and so on for each a new entry.
I hope it more clear now
Thanks in advance for help