Hi Matt,

I guess you are not getting me correctly..I am suggesting you to, just for getting solution and for the time being, have one workbook only with all the required sheet (though they are separate workbooks originally) and when you are satisfied with the solution you can have those sheets separated and change the reference of the formula later.

To more simply this, let me give you a example... if I want a solution from forum, where I need sheet 1 data of workbook A to be vlooked upon from sheet 7 of workbook B.... I'll move the sheet 7 from workbook B to workbook A and will post that one workbook to forum to do the formulation for me and then when I am satisfied with the solution, I'll edit the formula and have that reference to separate workbook on my pc....

this will avoid the encounter with linking issues.

Regards,
DILIPandey

<click on below 'star' if this helps>