Sum values in a dynamic range (contiguous cells in a table)

Hey everyone,

I have a bit of an issue that has been bugging me for weeks. Basically i have a worksheet that is copied and pasted into multiple other worksheets and one of the formula is a Sum function that sums all the values in the column (of the original worksheet).

The issue is the original worksheet Sum function uses a range of A1:A200 and this is copied into all the other sheets which may only have 1-20 rows of values and other tables above them. So basically values from other tables i don't want are being summed into the final calculations of these worksheets.

What i need is just a simple function that sums only the contiguous values in the table.

So if the function is placed in a 200 row table it will sum all 200 rows but if the function is placed in a 10 row table it will only sum 10 rows.

Thanks in advance

Edit: Btw, dynamic named range solution does not work because it is limited to 200 rows of data. I need to be able to deal with at least 20000 rows of data