Masters,

I am how zhang sheet in the workbook page of the attachment, including
Sheet page: first-level indicators, secondary indexes, page 12 these three sheet is fixed, the name is fixed,
Other sheet page is flexible, can increase can be reduced, such as the current sheet in the workbook page: technology, business, quality, service, the future may increase sheet page, page may also reduce the sheet, and is also the name of the flexible sheet page,

For help: 1, you can batch one by one the other flexible sheet page copy to the fixed page 12, delete the contents of the 12 pages before you copy, and then generate a new workbook (name=flexible sheet page the name of the workbook) workbook page only sheet: first-level indicators, secondary indicators, on page 12 of the three sheet, new workbook name is the name of the original workbook & amp; A specified flexible sheet and set the name of the page,
Citing steps: see attached workbook: for example. XLSM (note: copy is the content of the page sheet copy together)
Delete for example sheet page 12 pages of content
The copy sheet technology to 12 in the pages of
Generate the workbook: for example technology. XLSX (including sheet page: first-level indicators, secondary indicators, 12)
Delete for example sheet page 12 pages of content
The copy sheet in commerce to 12 pages in
Generate the workbook: for example business. XLSX (including sheet page: first-level indicators, secondary indicators, 12)
Delete for example sheet page 12 pages of content
Copy sheet in quality to 12 pages in
Generate the workbook: for example the quality. XLSX (including sheet page: first-level indicators, secondary indicators, 12)
Delete for example sheet page 12 pages of content
The copy sheet in service to 12 pages in
Generate the workbook: for example service. XLSX (including sheet page: first-level indicators, secondary indicators, 12)
To find whether there are other flexible, also found no end, so continue to repeat


Thank you, please help, thank you