I'm trying to extract 8 cells of data per row on an excel spreadsheet and place this information on a table on a powerpoint deck. I've prebuilt the tables on the powerpoint document but need the macro to push every 5th row to the next slide (limited to how much I can place on one slide).

Essentially it would be something like this:

Extract Cells: A5, B5, E5, G5, (etc)
Place on Slide 1, Row 1, text box 1 (through 8)
After the 4th row of data it would push row 5 to the next workbook and repeat.
Any blanks in the excel cell and it would put "N/A" on the powerpoint slide
If possible i'd like the font and font side to be Arial 14


Anyway, any assistance you can provide to this VBA newb would be very much appreciated.