u/Ok_Mountain_2888

hi there, i need help. i have multiple sheet for each staff that work part time. how can i get their name from each of this sheet, and make it as a list on new sheet. i have somewhere around 170sheet. their name is store in one cell on each sheet. hope someone could help.