Excel macro to re-arrange data

I have an excel sheet with two long columns (call them Column F and Column S) of text data with possibly upwards of 5000 rows. I need the first 80 pairs of data each transformed in one cell of an 10x8 matrix with "S" centered on the first line, then a blank line and then "F" centered on the third line.
Once the first 80 cells are filled with transformed data, the next 80 pairs are then transformed onto the second sheet and so forth through the entire length of the input data.
The cells are 94 pixels wide by 156 pixels high. Each cell has a border of the thinnest line available in excel. The 10x8 matrix will fill a standard 8 1/2 x 11 sheet of paper.
Some rules:
If data starts with leading blanks, then skip the blanks and start where there is actual text.
If there are pairs of empty cells, that line should be skipped. There is to be no output.
All output text is to be centered. Font is Arial, 12 point, bolded
If first cell in the input ("F") is empty, then process accordingly by putting "S" on the output top line as usual.
If the second cell in the pair ("S") is empty, then process accordingly by creating two blank lines and put "F" on the output third line.
If "S" is long enough to create a second line, then put "F" on the third line. That is, do not create a blank second line as text from "S" has occupied that line.
I will try to upload a sample source file and the start of a processed file.