Hello. My name is***** can help you with your question.
This would actually be a simple task to perform with VLookup. This is an Excel function that allows you to look in a certain range of cells for a particular text string. If the string is found then the cell value of the corresponding column is returned. This is normally used for looking up something like a price on a sheet with part numbers and prices for example. You could search that range for the part number and get back the price that corresponds that part number. But you could also set up so that the only corresponding cell that gets returned is the one with the name of the sheet. Then it would either return that value or none at all. There are other ways you can do this with formulas as well. I generally prefer to use formulas if it can be done that way because they don't break. And you really don't need VBA to do this – you have several options.