We have an Excel spreadsheet with multiple sheets/tabs. On the first tab we have a full list of clients. Each of the following tabs represent individual months in which migrations will take place, and contain subsets of the clients contained on the first tab.
On the first tab containing the complete list of clients, we want to know which month, and consequently which secondary tab, they are on. On all tabs each client is identified by a unique ID number.
Is there a way to match the IDs on the main list and notate which other sheet(s) they appear on? We would obviously not want to manually go through all the data, so if there's an at least semi-more automated way to complete this, it would be appreciated.