Pull/Copy data from multiple tabs in a workbook based on one Identification criteria

imapoboy2

New member
Joined
Jul 2, 2013
Messages
12
Reaction score
0
Points
1
Age
56
Location
Wisconsin
Excel Version(s)
2013
I am building a workbook that needs to pull changing data from multiple tabs to the Mastersheet (1st Tab). The formula/function will need to find / grab the data from each tab by an identifier. Lines are added and removed often, which is why I want to match/pull by the identifier. I really hope this all makes sense...

Example:

Mastersheet - Cell A3 (Identifier) = JOB123
Cell E3 (Current Hours) = Tab-2, Cell B1
Cell F3 (Total Hours) = Tab-2, Cell B5
Cell H3 (Overtime) = Tab-3, Cell D2

Tab-2 - Cell A1 (Identifier) = JOB123
Cell B1 (Current Hours)
Cell B5 (Total Hours)

Tab-3 - Cell B2 (Identifier) = JOB123
Cell D2 (Overtime Hours)
 
Back
Top