Adding another step...

[Mike1w]

I am trying to add another step to the associated macro and I am having a problem. (refer to macro below)
Is there any way to look-up a "filevalue" (tab) in a workbook where multiple worksheets are present? So the Macro would look into another workbook, find the tab and return the values requested? Or would each tab / worksheet need to be it's own file? Is this Possible? I was trying to figure out what I would have to include if the tab / worksheet was in a seperate file. Thanks in advance.

Private Sub sub3()
'
'Sub Loads #3'
'
Dim filevalue
filevalue = Cells(128, 5).Value
'L load'
Range("K129").Value = "=" & filevalue & "!K95"
'R Load'
Range("K130").Value = "=" & filevalue & "!K96"
'E Load'
Range("K131").Value = "=" & filevalue & "!K97"
'K Load'
Range("K132").Value = "=" & filevalue & "!K98"
'S Load'
Range("K133").Value = "=" & filevalue & "!K99"
End If
End Sub

[Mike1w]

Would it be possible to pull the tab from an associated file within the same folder structure??