Excel formula with Dynamic wookbook name, static sheet name

[Lotus User]

=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. I'm using Excel 2010. Any suggestions?

<tbody>
</tbody>

 

[Fluff]

Cross posted https://stackoverflow.com/questions/48214336/excel-formula-with-dynamic-file-name-static-sheet-name

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Lotus User]

Thanks for the Intel. I have no idea what that means but I will read it. new member blunder...2 different websites with 2 different log on's required...who knew?? I'm sure it all makes sense to tech savvy people. I'm just looking for an answer to my formula problem. didn't get any response on one website so I tried another.

 

[Fluff]

You'll find that a lot of members on this site, also post on other sites, so a lot of cross posts are spotted & reported.

This site has a very good explanation about cross posting
https://www.mrexcel.com/forum/redirect-to/?redirect=http%3A%2F%2Fwww.excelguru.ca%2Fcontent.php%3F184

ps don't forget to read our rules as well