Consolidate 4 different tabs in one aditional tab

[morrisc]

Hi, I kind of new on this, and I will really appreciate some help.
I have a file with 9 tabs one of them is "Data" the master one.
Each of the tabs ("User1, User2,User3,User4") has several columns but I need to consolidate only from column T6 to Y6
I need to consolidate "User1, User2,User3,User4 in the Data tab (in the same columns T6 to Y6)
The thing is that the users are updated daily so kind of lost how to reflect that in vba so I don t loose data not updated.
Besides Ive been asked that every user has access only to his assigned tab...user1 etc and the manger can view all.

 

[arthurbr]

The consolidation part has been solved over and over on the forum. Try searching around (hint : Ron de Bruin)
As for the latter, perhaps use sheet protection with different passwords?