Macro to extract data when certain criteria met

Hi,

I am looking for some help in extracting data from multiple workbooks into a new one.

What i need is to extract the "name of staff" as well as Name, address, postcode, Price 1, Price 2 from multiple books into a new workbook, if the date column has "tba" in it. The fields are all in the same place across the 5 books and I have added an example sheet for people to look at.

I hope someone can help me and thank you in advance