If column 1 in the top table = 'yes' I want to copy column 2 & 3 into the table below columns 1 & 2.

wumolad  What I believe Mark is asking about is if you change row 9 (cabling under floor) from yes to no the table on page 4 leaves the row that previously had that row information at a very tall row height even though the new row doesn't require it.  Conversely if you autoheight the rows without "row 9" selected and they are all short/normal height then when you add "row 9" the wrapped info is cut off. 

@Mark_Bry  First off, being a quality & regulatory person I loved seeing this risk assessment. lol.  And by RAMS is that from Emergo?  Regardless, I'm wondering why you don't use a pivot table for this?  I have mocked one in the attached workbook.  after you make a change you do need to 'refresh' (alt-F5) but it seems to work pretty well.  Formatting still needed to make it look pretty...

Also you should know that 2 limitations of the solution you are using include:

a) if you copy that formula down to row 30 for example but you have more "yes" items than the number of rows you copied that formula into then the list will be truncated (i.e. some "yes" rows not shown).  Of course you can just copy that into 100 or a few hundred rows to be sure but that isn't great and you'll need to deal with page formatting as excel will think all those rows have values.  Another option is to do something realistic (let's say 50 even though I know risk assessments can be very large) and then create a "warning" (I usually do it somewhere near the top left) that checks if that last cell has data in it to check if additional rows of formula are needed.  

b) all those array formulas can slow down excel.  Now in my case I switch from a formula like that to pivot tables in a sheet where we had thousands of lines and although some of my risk assessments have hundreds of lines I doubt any of them reached thousands so this may not be too much of a concern.