Hi,
I am trying to create a summary table of a few cells from each sheet I have in a single workbook. Which is simple enough, but I want to find a way if possible to have the summary table update when I add new Sheets to the workbook.
As an example in every sheet in:
- Cell A1 = person name
- Cell A2 = Date of an evaluation
- Cell A3 = Position of person
- Cell E50 = overall evaluation score
So summary sheet should in column A list all the names of people, B the date of evaluation, c position etc....
So as and when new evaluations are entered they show in summary table.
thanks for any help !
I am trying to create a summary table of a few cells from each sheet I have in a single workbook. Which is simple enough, but I want to find a way if possible to have the summary table update when I add new Sheets to the workbook.
As an example in every sheet in:
- Cell A1 = person name
- Cell A2 = Date of an evaluation
- Cell A3 = Position of person
- Cell E50 = overall evaluation score
So summary sheet should in column A list all the names of people, B the date of evaluation, c position etc....
So as and when new evaluations are entered they show in summary table.
thanks for any help !