new data needs to be updated into a table

hi,

I attached a workbook which shows the result I am looking to get

I want the new data to be formatted into 3 tables.

My issue is trying to count the row length for the new data (what if its just a few lines of data?)

also,

I have three tables that need to take the size of the new data each time.

Can anyone advise?

The data changes and the pivot table won't meet certain format characteristics I need and changing the source data would have to be done manually to ensure data integrity