Hi So I have this general sheet that I split into 6 excel files. The 6 files have the same tabs for the dates of the month with the general sheet but have different arrangement as these are split into each team of my organization.

How do I make it easier for me to incorporate the data for each member ID on each of these tabs to the general file of the same ID and same tabs?

I'm not sure if I made sense, but I'm an excel newbie and I'm a bit slow on things. Please help.
Thank you!