Summarising information from a control sheet to other tabs using formula

[tkiernan92_]

Hi, new to the site so apologies if this has been asked before!

I have a spreadsheet of data with all my source info included in the control sheet referred to as 'master'. This information spans columns B-CA and rows 20-2000. The information relates to different sections of a construction project 1-6. I would like a formula that selects all the lines of 'section information' so either 1,2,3,4,5 or 6) and summaries it in another tab, i.e. one tab for section 1, 2, 3 and so on, which captures all information on that line from column B-CA and is consecutive from row 20,21,22 etc. (no gaps). This will allow the master tab to control the other tabs and save a lot of time. If the formula could also pick up new items that are added to the schedule that would be very helpful, possibly through adjusting of the range?

I've included a brief example of the kind of data source I have below.

Hope this has been explained clearly but if not please ask for clarification and any responses are gratefully received.

Thanks very much,
Tom

Type of work	Section	Ref	Description
Cons	2	CW-123	Earthworks
Cons	1	CW-124	Drainage
Cons	3	CW-125	Pavements
Cons	1	CW-126	Structures
Cons	4	CW-127	Archaeology
Cons	1	CW-128	Lighting
Cons	2	CW-129	Utilities
Cons	1	CW-130	Temp Works

<colgroup><col width="116" style="width: 87pt; mso-width-source: userset; mso-width-alt: 4242;"> <col width="113" style="width: 85pt; mso-width-source: userset; mso-width-alt: 4132;"> <col width="64" style="width: 48pt;"> <col width="270" style="width: 203pt; mso-width-source: userset; mso-width-alt: 9874;"> <tbody> </tbody>