Is there a way to use a worksheet range that spans multiple worksheets to select all names (Column A) from the 10th worksheet to last one.
I then want to sort this list and remove duplicates to build list that includes all staff that have worked any pay periods for the year.