Dynamic Sheet Referencing

[bmw4life]

Hello All,

I have an index match function in one sheet which is pulling data from another workbook. Both workbooks have the exact same tab titles/names and I wanted to use a dynamic formula where the sheet name I'm working on would just go to the other workbook, look for the same sheet name and apply the index match formula and return the values to my workbook. Is this possible?

Thanks!

 

[eduzs]

What formula are you currently using?

 

[bmw4life]

For individual cells in the sheet I'm using Index (separate worksheet reference),MATCH("line item",separate worksheet reference)