copying column headers from multiple sheets into a "summary" sheet, based on criteria

In my head this seems like it should be straight forward. A breakdown of what I have (with attached spreadsheet):

I have 8 sheets all with the first 2 columns containing the same information.

Within each of these sheets there are columns with unique IDs (series of letters followed by a number which corresponds to the sheet that ID can be found on, see below)

screengrab1.jpg

What I'm looking for is a formula/array formula? that will search through row 2 of all 8 sheets, and create a new table in "summary sheet 1" where the column headers are those where the area ID's contain a "1" e.g. M1, LLL1 etc (with the idea that I'd then create 3 other sheets for ID's containing a 2, 3 and 4). and to also copy across the associated information from row 3

Once this has been achieved I then need a way for all the numbers in the respective columns to also be copied across into the summary sheet i.e. 30,119 and 149 etc.

One extra snag. I need the summary sheet to also update in the event that additional area ID's are added to one of the sheets. e.g. if in the attached screen grab I add an area ID labelled NNN1 in Column BB, I need the formula to add the info from NNN1 to "Summary Sheet 1"

The general outcome I'm looking for is 4 summary sheets with all of the Area IDs with the same number in each sheet. Column A and B will also be copied across into each of the Summary sheets so that I can sum the total number of each plant type as well as the final total for the number of plants in that sheet.

I hope all of this makes sense and that there's someone out there in the world who knows what I'm after and can help!

any help would be massively appreciated (I'm doing this for the Mrs, I'm semi proficient with excel but even this has got me stumped!)

Cheers,

Dan