Hello,

New to the forum but learning loads already but I have a specific query i'm struggling with.

I have a workbook containing multiple sheets, each with a single column of unique premises reference numbers. Each tab is individually named. I'll be doing a daily database extract into the front sheet of this workbook. This will include a UPRN for each property extracted from the database.

I need a macro that will look at each UPRN on the front sheet, search all the other worksheets and return the name of the tab where a match is found, and put that into the front sheet in a specified column. Basically the tab name will be a route number that we will then mailmerge along with all the other information from the front sheet into the notification letters to everyone on the database for that day.

I'm a little concerned about volumes as each route tab could have 10 000 UPRNs, there will be 10 tabs/routes.

I can however list each tab in ascending order to utilise the VLOOKUP function, but possibly need to be looking at INDEXMATCH instead as over time, additional UPRN's will be added to each route.

Any assistance or advice will be gratefully appreciated!