Sheets 1-6 are a list of names with values next to them. On the Master sheet I need to have sheets 1-6 (names & values) merge.
Each sheet is a separate team and they will shift between each other. At this point they are so fluid that I think of them as liquids. So I can't just do a simple reference. The Master must take the names and values and then combine them into the Master sheet and sort A-Z.
Attached is an example workbook.
Bookmarks