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