Populate table in one tab by retrieving data from another tab

Hello,

At work I am following up on manufacturing hours on busses. Each buss manufacturing work is splitted into 5 "takts". Each takt consist of activities, column called "system name" throughout all takts. Takts cannot overlap, T2 can only start when T1 is finished and so on. Meaning that we track this based on time frames(weeks).

We are tracking actual hours stamped vs forecastes hours vs budgeted hours per buss, takt and system name(activities).

The first tab("TS") where all data is, is to me very messy. I have taken over this file from my manager and he does not want me to make any changes. He updates tab "Consolidated table" manually but I would like to check if there is any possibility to automatize this with formulas.

As new busses arrive to the workshop, right now ST9 and ST11 in production, soon ST10 and ST12 will arrive meaning that these will be inserted to the right, as we go along we will end up with 20 busess.(just some background info).

Some tables are pivot tables (the actual hours tables) and the rest are just regular tables... the amount of columns of the tables vary due to delays or rework, replanning may happen.
Also notice that in tab "TS" each table has the belonging takt in column C for ST9 and column R for ST11.
Anyone know if this is doable?


Thank you
C