Excel 2007 : Concatenation

This is likely better addressed in Access, but my employer chose not to buy the same.

I would like to concatenate two columns of text. The first is a list of prefixes 1407 rows long, The second is a list of suffixes 75 rows long.

I would like column A on Page 2 to be the concatenation of Page 1, A1 + B1 through B75. Column B (Page 2) to be the concatenation of Page 1, A2 + B1 through B75, and so forth.

How can write the correct formula once and then copy it so that I get the above result?

Thanks!

=OFFSET(Sheet1!$A$1,COLUMN(Sheet2!A1),0)&Sheet1!$B1