Auto search the worksheet name and use it in report
 

Hello,

I have a spread sheet with dynamic number of work sheets by name Tina, Andrew, Smith. ( The number of work sheets can be one to many) I would have a last sheet as Summary which should auto populate the names from the sheets in column A and some values from respective sheets in column B.

Sheets Name 1, Name 2, Name 3 ... n I am going to have one sheet as fixed "Summary" with three columns Named , Name Score Percent
Values come from - Name : Sheet name
Score : D45 of every sheet
Percent: E6 of each sheet.

If I add a name sheet by mistake, there are chances that I would delete one of those sheets at any time.

I would also need to create such sheets every week for work. I would prefer to keep on template and re-use it.

Unable to attach sheet with sample data..

Kindly advise.

Thanks.