Adding rows to a table based on text in another table.

Hi All, I'm using Excel for project management in a single workbook. I set up one sheet for all Site data (named General) which includes Site ID (the master key), Address, Contact details, etc. The...