hi all, i have 2 workbook. WB1 is named SCORESHEET and WB2 named MASTER. WB1 is template for my staff (+-50 staffs) to log in data daily. It contains only 1 sheet and the name is selected via dropdown button. Date to keyed in daily based on their working day. The score in WB1 will accumulate daily based on data keyed in. The staff are required to save and send this myself.

WB2 contains multiple sheets (+-50) named based on the staff. There is template in all the sheet and it is the same except for the name on each sheet.

I require a macro which copies selected cell value from WB1 into WB2 according to name of the staff, date and the score accordingly. The WB2 will be saved in network but staffs are not allowed to open it.

attached is the workbook sample.Scoresheet.xlsmMASTER.xlsm