Domenic, I have one more spin on this. In cell G1 for each of my several wksts whose name begins with "Series", I have the following formula entered in the cell

**=VLOOKUP($F$3,Main!$B$7:$C$12,2,FALSE)**
If the range in my VLOOKUP ever changes, I'm stuck going through an manually readjusting the forumla in cell G1 for each of my series worksheets. However if I was able to reference the cell to a function in vba that holds my VLOOKUP formula, I would only need to change the formula in the VBA code as opposed to going to each G1 cell in my series worksheets. So instead of typing out the VLOOKUP formula in G1, I would just input the function, e.g.,

G1VlookUP(), in the cell instead.
I suppose the logic would flow something like this...

Function G1VlookUP()
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Worksheets
If UCase(WS.Name) Like "*SERIES*" Cell Equals G1 Then
G1.value = **VLOOKUP($F$3,Main!$B$7:$C$12,2,FALSE)**
End If
Next WS
End Function
Any ideas how to put this into a code that will work?

Thanks!