Copying Data from one workbook to another.

Hey everyone, I'm working with a large workbook, we'll call it workbookA, which is very large encompassing all the data for a Project I’m working on. Column A has different locations and column F has a corresponding number and G has the unit code. In Workbook B one of the spreadsheets has a rating system for each of these numbers. Is it possible to set up a formula or macro so if you add a row because you found a new “corresponding number” in workbook A in one of the locations, it automatically adds a new row in the rating spreadsheet in workbook B?