How to have excel pull data from multiple workbooks that meet certain criteria ?

[NightmarePHD]

Hello I have 4 works books premade that are used to track attendance well I would like to make a master work book that basically combined all the works into one with all the info with them, but I want it to update as they enter in or change information.

2 of the work books look like this and the other 2 are the same expect they do not have the Lane column.

I want the master copy to take all the names driver code and lane ( I can add lane to the other two if need be) and the day of the week data and make it one long list that updates as everyone uses it weekly 52 tabs total for every week in the year.

 

[ACCERBYSS]

Hey NightmarePHD you could do this with power query, and get data from folder, requires Excel 2016 or above. I highly recommend ExcelIsFun's youtube videos on the topic.

 

[NightmarePHD]

Hey NightmarePHD you could do this with power query, and get data from folder, requires Excel 2016 or above. I highly recommend ExcelIsFun's youtube videos on the topic.

unfortunately we do not have 2016 that nor the funds for it.