Using cell values to reference sheets

In order to reference a different sheet, you cannot just use an "&" operator because excel will refer to the cell as text. You must use the indirect function.

For example, if you want to extract data from Sheet A@C, cell A1, try this:

=INDIRECT("'"&A1&"@"&B1&"'!"&"A1")

Using the function =INDIRECT("'"&C4&"@"&B4&A4&"'!F2") was good but when I copy and paste even though the next row formula is =INDIRECT("'"&C3&"@"&B3&A3&"'!F2") it still shows the number from the original function down the entire page. But if I delete one og the copies and manually type in the function, it now changes to the correct number from the correct sheet. I am sure I am doing something wrong but cant figure it out. If you could help me once more it would be greatly appreciated.

Unfortunately, the cell reference has to be in quotations, as the indirect function looks for the reference of the contents of the cell. The only way to accomodate the indirect function for your needs is to set it up using the row function.

It is very difficult for me to setup this function for you without seeing a sample of your work, and how it is setup, but here is a try:

=INDIRECT("'"&C4&"@"&B4&A4&"'!"&"F"&ROW())

Thanks for all the help it was in my options settings...somehow got on manual instead of automatic. Once again ty guys.