That works for everything except the Material Specifications. For that I will have to use a macro. I believe that I can use

Select Case ActiveSheet.Range()

to actually select the worksheet. The problem I am having is that I don't know how to initiate the command or how to go to a command that will basically use the vlookup on the selected sheet. The only way that I know how to do this is to use an if() statement with all of 15 sheets defined in it.

I will try that for now but if anyone can suggest an easier/better way, I would be most grateful.

Thanks

Shane