Write Output(Report) page with VBA

Good Morning,

I have a workbook that has six sheets and five of the sheets contain data and the six sheet is the one i am trying to use for a report.

Problem: If i add/delete any driver from the first five sheets than I must go back and rebuild the whole report sheet.

From the five data sheets I need to pull driver name, time sheet yes/no, than any date of a log turn in throughout the week. There is other data on the sheets but this is the only data i need for a report. I am creating a Roster of driver's and the paperwork they have turned in.

Rebuilding the report sheet is way to time consuming. So this happens if we hire a new driver or lose a driver.

Driver ---------- TimeSheet -----------------Logs
Fred------------------Yes----------------- 12/1 12/3 12/4
Dave------------------No-------------------------12/3
George---------------yes-----------------12/1----------12/4


That is what the Report sheet looks like.

I have no idea how to attack this project. Any idea will be greatly appreciated.

So it let me add the actually workbook. This is how i use it to day so from the actual plant sheets i want to create a roster showing what a driver has turned in as far as time sheets and logs. I currently use formulas to do this but if there is any changes to the drivers than my roster is no longer accurate or usable. That is til i rebuild the roster.

So I am thinking that using vba I could get it to build the roster every time I click the roster sheet or maybe put a button on roster sheet saying "click for most updated roster"

Thanks