Generating a table based on data from other worksheets

[reynastus2]

Hi All

I have had some assistance with part of this project before and have managed to do some further work on it and now was looking at implementing the final part of this workbook.

the workbook is a roster for work and I would like it to be able to generate a single page roster based on the worklists for each week (on worksheets Week 1, Week 2, Week 3, Week 4) using the shift codes next to the name on the worklist.

The roster template is located on the worksheet Roster

please find attached a copy of the workbook that has some dummy shifts placed in the worklists
Example template ver 3f.xlsm

Thanks for the assistance

Rey