Help referencing a file

[Munkle555]

Hello would anyone mind giving me a hand with the indirect function but let me start with what I am trying to achieve basically I will have a list of excel documents which are all invoices containing a cell with cash values and they will all be named the same except the digit at the end is incremented by 1 so what I want is a excel document that can pull the cash value from each invoice but I want it to pull the name of the file from a cell which I will input the name of the invoice. So far I have two test documents and in the first I have A1 as the excel document name B1 as the sheet name and C1 as the cell I want to the pull the info from and I have created a seperate spreadsheet with the same name as in A1 and the same sheet names as in B1 and placed random data in C1 and used this code to pull from it =INDIRECT("'["&A1&".xlsx]"&B1&"'!"&C1). This works however I want to make it so rather then using the values of B1 and C1 I can just type in a sheet name and cell name as this will remain a constant but any way I try and enter it, it will not accept it. Any help would be great and thank you in advance.

[ragulduy]

=INDIRECT("'["&A1&".xlsx]Sheetname'!A1").

[Munkle555]

You sir are a legend. Thank you very much

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.