I am dumbfounded making a macro to do the following (unsure if even possible):

If name (I.e. Smith,John) in AB19, matches AB19 in Workbook “STK” then copy cells A1:T6 into A1. It would need to match AB19 to AB19 across a workbook of over 100 sheets though i.e. if no match in the first sheet, try the second and so forth.

After matching and copying, it would then move onto the next sheet in the active workbook and do the same thing for AB19 in the next sheet and continue through all sheets until the end.

Thanks