split Tables into multiple Tables for multiple sheets with different structure & arranging

As you do not answer how 'tt' data is allocated …

what do you mean ?
can you clarify more pleas?

If you have well read post #81, Option #2 - like Option #1 - updates only the unique individual worksheet relative to which 'tt' cell changed …
The difference between both is Option #1 trying to be smarter with updating only the necessary when possible
rather than Option #2 updating all the relative unique individual worksheet even when only a 'tt' cell changes …
Well notice above like in post #81 I did not write worksheets but worksheet without an 's' so a single unique one.

now definitely I select option1
EDITED FILE: post#36 with simple adjusting.