Excel question - extracting subtotal results

[IronWing]

I have some information in Excel like so:

Name    Room    Item
Martha    101    desk
Martha    101    chair
Martha    101    cabinet
Martha    102    stool
Martha    102    scale
Martha    102    microscope
Martha    102    beaker
Martha    102    burner
Martha    102    flask
Bob    103    desk
Bob    103    chair
Bob    103    cabinet
Bob    103    book shelf
Bob    103    marker board
Bob    104    stool
Bob    104    scale
Bob    104    microscope
Bob    104    beaker
Bob    104    burner
Bob    104    flask
Jane    105    desk
Jane    105    chair
Jane    106    stool
Jane    106    scale
Jane    106    microscope
Jane    106    beaker
Jane    106    burner
Jane    106    flask

I use the subtotal function to summarize the number of items in each room:

Name    Room    Item
Martha    101    desk
Martha    101    chair
Martha    101    cabinet
    101 Count    3
Martha    102    stool
Martha    102    scale
Martha    102    microscope
Martha    102    beaker
Martha    102    burner
Martha    102    flask
    102 Count    6
Bob    103    desk
Bob    103    chair
Bob    103    cabinet
Bob    103    book shelf
Bob    103    marker board
    103 Count    5
Bob    104    stool
Bob    104    scale
Bob    104    microscope
Bob    104    beaker
Bob    104    burner
Bob    104    flask
    104 Count    6
Jane    105    desk
Jane    105    chair
    105 Count    2
Jane    106    stool
Jane    106    scale
Jane    106    microscope
Jane    106    beaker
Jane    106    burner
Jane    106    flask
    106 Count    6
    Grand Count    28

I collapse the table to just show the subtotal results:

Name    Room    Item
    101 Count    3
    102 Count    6
    103 Count    5
    104 Count    6
    105 Count    2
    106 Count    6
    Grand Count    28

I would like to now copy just the summary lines to a new sheet in the notebook, maintaining the live links. Any idea on how to do this? I can do it statically by line number but if the number of items changes, the links would be no good.

 

[hardhat]

Move the subtotal and total sections to column 4/5, so they don't lose their cell if you add rows?