Time controlled display in excel

Hi,
I'm trying to create a display on a sheet in excel that is driven by another sheet of simple data. The display sheet will show only one row of data at a time, whilst the source which is on another sheet selects the data row by row controlled by a time delay. The display will show time on a 24hr range and stop once it is completed. The data shown will be of three categories and show "out" or "back". Each category has the out or back set at differing intervals so the category 1 will have say 12 pairs, the second 8 pairs and the third 3 pairs. There will be times when a category is empty. I'm fairly new to Macro work but this one has got me stumped. Where do I start?
Brian