Formula to pull only cells with data from one sheet to a consolidated sheet

I am trying to pull information from a sheet in which I paste in downloaded info from my website. Since the creators of that site can't give me what I need I am attempting to set up my own worksheet. I need only the cells on Sheet 1 in columns F, G and H that have a formula result to pull to pull to sheet 7 without the blank lines between. Ideally it would be nice if it also sorted that date by the earliest time ordered.

I would also like to say that everything I know about excel has been learned from the site. I consider myself intermediate, not to knowledgeable with VBA but I can create macros that are simple. So thanks for all you help