Automatically filling a table

I posted a couple of days ago with a problem to get information from tables on sheets 2-7 and put them on page 1. I've simplified my problem now though.

On sheet 1 I have columns;
Variant Date Test Result Notes

On sheet 2-7 I have various tests with different but similar columns.

Now on sheet 8 (which I intend to be a hidden sheet) I have gathered the information from sheets 2-7 to make a very long table. It has the same columns as sheet 1.

I just need to get data off sheet 8 and put it in sheet 1, but I don't want all the blank rows from sheet 8, and I'd like it to automatically organise the data in chronological order if possible.

How can I do this? By simply putting the data in a table and using a filter to get rid of the blanks, it displays what I want it to. I'd just like it to update automatically now.