Excel 2010 formula with Dynamic wookbook name, static sheet name

=INDIRECT(ADDRESS(65,20,1,1,VLOOKUP(C$4,FILELOCATION,2,FALSE)&C$4&$B$2&".XLS"))

I created the formula above to pull info from a source workbook(dynamic name) into a summary workbook. Source file name will be dynamic plus I will have 10 source files to pull into the summary workbook.
This formula works when the cell T65(65,20) is in Sheet1 of the workbook.
How do I alter the formula to pull from sheets other than Sheet1? I am trying to pull data from Sheet6 (in the source file) which is called Budget Export.
I don't know macros so this is why I am trying to stick with formulas.

The VLOOKUP just creates the path for the file name but it doesn't reference the Sheet so it seems to be defaulting to Sheet1.

This is the path the VLOOKUP creates:
U:\Public - Everyone\HealthServices\Nursing Analysis\FYE2018\WPT\WWP 2018-0106.xls'!$T$65


Any suggestions of where I reference the sheet name in the formula?

I suppose you must single quote the path and filename.
Try
=INDIRECT("'" & ADDRESS(65,20,1,1,VLOOKUP(C$4,FILELOCATION,2,FALSE)&C$4&$B$2&".XLS"))

hmmm...no luck...any other suggestions? I'll keep plugging away..

yes, it's open

Use

'path[filename]'sheetname!celladdress