If you're moving your information between tables, can you lump the
tables together on another worksheet and refer to those cells from the
current tables? That is, B18 in your table area would reference A1 in
the contiguous table, C18 would reference B1, D18 would ref C1. B19
references A2, C19 refs B2, D19 refs C2, and so on. B52 would
reference the row after the one B32 references.

This way you should be able to easily modify voodooJoe's code to work
on the contiguous data and have it display correctly in your tables.