Hi guys,
I'm needing to retrieve names that can range from A2:A100 across 13 different sheets to form a list in column A of the summary page which includes every name from each sheet and updates automatically when new names are added to various sheets. See sample spreadsheet attached. I've only included 4 names per sheet for this exercise but any could have up to 100.
Thanks!
Bookmarks