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

[TABLE="width: 423"]
<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>[TR]
[TD="width: 116, bgcolor: transparent"]Type of work [/TD]
[TD="width: 113, bgcolor: transparent"]Section [/TD]
[TD="width: 64, bgcolor: transparent"]Ref[/TD]
[TD="width: 270, bgcolor: transparent"]Description [/TD]
[/TR]
[TR]
[TD="class: xl70, width: 116, bgcolor: #CCFFFF"]Cons[/TD]
[TD="class: xl71, width: 113, bgcolor: #CCFFFF"]2[/TD]
[TD="class: xl70, width: 64, bgcolor: #CCFFFF"]CW-123[/TD]
[TD="class: xl72, width: 270, bgcolor: #CCFFFF"]Earthworks [/TD]
[/TR]
[TR]
[TD="class: xl70, width: 116, bgcolor: #CCFFFF"]Cons[/TD]
[TD="class: xl71, width: 113, bgcolor: #CCFFFF"]1[/TD]
[TD="class: xl70, width: 64, bgcolor: #CCFFFF"]CW-124[/TD]
[TD="class: xl72, width: 270, bgcolor: #CCFFFF"]Drainage[/TD]
[/TR]
[TR]
[TD="class: xl70, width: 116, bgcolor: #CCFFFF"]Cons[/TD]
[TD="class: xl71, width: 113, bgcolor: #CCFFFF"]3[/TD]
[TD="class: xl70, width: 64, bgcolor: #CCFFFF"]CW-125[/TD]
[TD="class: xl72, width: 270, bgcolor: #CCFFFF"]Pavements [/TD]
[/TR]
[TR]
[TD="class: xl70, width: 116, bgcolor: #CCFFFF"]Cons[/TD]
[TD="class: xl71, width: 113, bgcolor: #CCFFFF"]1[/TD]
[TD="class: xl70, width: 64, bgcolor: #CCFFFF"]CW-126[/TD]
[TD="class: xl72, width: 270, bgcolor: #CCFFFF"]Structures [/TD]
[/TR]
[TR]
[TD="class: xl70, width: 116, bgcolor: #CCFFFF"]Cons[/TD]
[TD="class: xl71, width: 113, bgcolor: #CCFFFF"]4[/TD]
[TD="class: xl70, width: 64, bgcolor: #CCFFFF"]CW-127[/TD]
[TD="class: xl72, width: 270, bgcolor: #CCFFFF"]Archaeology [/TD]
[/TR]
[TR]
[TD="class: xl70, width: 116, bgcolor: #CCFFFF"]Cons[/TD]
[TD="class: xl71, width: 113, bgcolor: #CCFFFF"]1[/TD]
[TD="class: xl70, width: 64, bgcolor: #CCFFFF"]CW-128[/TD]
[TD="class: xl72, width: 270, bgcolor: #CCFFFF"]Lighting [/TD]
[/TR]
[TR]
[TD="class: xl70, width: 116, bgcolor: #CCFFFF"]Cons[/TD]
[TD="class: xl71, width: 113, bgcolor: #CCFFFF"]2[/TD]
[TD="class: xl70, width: 64, bgcolor: #CCFFFF"]CW-129[/TD]
[TD="class: xl72, width: 270, bgcolor: #CCFFFF"]Utilities [/TD]
[/TR]
[TR]
[TD="class: xl70, width: 116, bgcolor: #CCFFFF"]Cons
[/TD]
[TD="class: xl71, width: 113, bgcolor: #CCFFFF"]1[/TD]
[TD="class: xl70, width: 64, bgcolor: #CCFFFF"]CW-130[/TD]
[TD="class: xl72, width: 270, bgcolor: #CCFFFF"]Temp Works [/TD]
[/TR]
</tbody>[/TABLE]