Running a simple regression over multiple sheets then calculate another sheet?

[surfdoc37]

Kind of two questions in one here.

I have some straightforward data in two columns. "A" is just the ranking 12 highest, 1 lowest while "B" is the quantity counted.

Have each year, on a different sheet. Were in different workbooks but step one seemed to be to make a single workbook.

I wish to run a regression on A1:A12 on sheet one AND A1:A12 on sheet two versus B1:B12 on sheet one AND B1:B12 on sheet two.

(If I just stack them on top of each other (A1:A24, ie) it is easy but it screws up the basic annual data.)

Can I do that, or, stuck with stacking them in the same sheet?

Then I want to use the output on a third sheet to calculate the "B" column values for A1:A12 which would again descend from 12 to 1.