In Excel I'd like to search across multiple worksheets without having specifically to give the name of each one, so if I add a sheet it will look across that sheet too. I know how to look across sheets with IFERROR and VLOOKUP but with these functions I have to specifically add in each worksheet.
Is this possible without writing code?
