How do I run data range in one workbook through a calculation in a separate workbook

Hi,

Is it possible to have a column of data (a1:z1) in one workbook (WB1) be run through a calculation spreadsheet in another workbook (WB2) with say an input cell B2 and output value cell M9, and then have the outputted values in WB2 cell M9 to be put in the column next to the column of inputted values i.e. WB1 (a2:z2)?

Many Thanks,

Paul