Summarize One Sheet With Other Sheets on a criteria

Hi Guys

I’m new to excel programming so need your help for one of my projects

I had to make a summary sheet which do contains all the sheet name in a row and a column above that do also contains all the related metrics which r the part of these sheet names


E.g.

A, B, C are the sheets name

& what I had to done is match the Metrics
e.g.
Productivity %
On time
Abandoned
Abandoned %
Critical Error Accuracy
Non-Critical Error Accuracy
which do belong to different worksheets such as
A contains productivity% to abandon%
B Has only 1st 3
C has later
so I had bring data to summary sheet through a combo box selection
which do contain months name
data on each sheet is also primarily month based
if i select April all the summary sheet are filled with all relative metrics

Till now I had [done all this with the help of a forum Member Antonio (Antoka05)

Sheets name are also added on run time in the sheet

These sheets basically do contains the work types of my project
Where sheet B is the one which contains “other work types”

Area of my concern is that I had to include all those work types named type1, type2 etc (which can be of any number)

So I had to populate these types with this sheet also in the summary sheet
what I need is

in the list which I had created as a array
A
B after b
It should contain all the types also which are present in the table B
C

what exactly i do need is macro updation
Sorry for the jumble language I’m still in the learning process of technical terms

Plz help me with this
I’m Attaching the file as well as code which I had used to run the sheet