fill cells on multiple sheets from columns of different lengths

[bboyd]

I have a table. Columns have a company name as a header and a list of employees. I want to autopopulate the cells on multiple pages from the list of employees, without any blanks.vEach page has a spot for 8 names, A2, C2, E2, G2, A5, C5, E5, G5.
From the table i want to populate these cells on sequential pages until all the names from the table are used.

[Bernie Deitrick]

I _think_ this will work. If you list is in column A of Sheet1, starting in cell A2, on the next sheet (with the 8 spots) enter this formula in cell A2 and enter 1 into cell Z1 (or change the $Z$1 to another free cell):

=INDEX(Sheet1!$A:$A,IF(ROW()=2,0,4)+(COLUMN(A$1)+1)/2+$Z$1)

Then copy that formula to C2, E2, etc. and then on the next sheets, use the same formulas but enter 9 into cell Z1, then 17, 25, 33, etc