VB Code to Create summary schedule by bringing schedule data from different sheet

Hello:

Please refer to attached file.

LJ,WE,EL,BN,,etc until TN are the Name of the stores.
In each of the tab, I will be creating work schedule.

I need VB Code to do following task.
Sheet "FullSch" will have list of all Employees.

I need to go thru each employee and see if he/she is scheduled in any of the
stores LJ Thru TN.
If they are then bring and enter the schdeule time and Name of the store in
the day column C thru I.

I have manually created 2 employees "Colleen Laird, Linda Pater "information as shown

Let me know if you have any questions.
Thanks.

R

Hello Bo and nan

Great work, thanks a lot, it works

R