How do I make sure new rows and/or columns are added to a table when source is updated?

Hi guys,

Basically, I am working on financial analysis and there are a lot of link within the file. I have a bunch of worksheets that link to each other, the difference being how they are presented. So, what I would like to do is for one worksheet to know to add a row and possibly a column when a row or a column are added in the linked source worksheet. I've attached an example. Let's say I am entering a new account 51200 in row 8 in the Detail worksheet, how do I make sure the Summary tab picks up this row automatically? so that I don't have to manually go in and insert a row in the summary tab.

Thx!

I see. I also remembering seeing it done using the function Indirect and then referring to the range to which the output table is linked. Do you have know how that is used by chance?

Thx