Need help in excel

I'm try to run a multiple regression using LINEST. However, my two independent variables are located in different worksheets. Is there a way to run LINEST anyways, or do I have to move them together?

My question deals specifically with having multiple independent variables located at different worksheets. So, the formula would be =LINEST(A1:A2,B1:C2). Now imagine that we keep column B where it is, but move column C to a different worksheet. Is there a way to still use LINEST? Moreover, this question relates to all array formulas in general, not only LINEST.

Thank you

Sure. Excel functions can reference other workbooks:

LINEST(F5:F8,'C:\$user\Excel\[junk2.xls]Sheet1'!$A$1:$A$4)

The other workbook can be open or closed.