Thanks for the reply Pepe, It doesn't quite cover all I need to do though. I will use it for linking the workbooks together initially.

It's multiple small single sheet workbooks all updating one master file. I'll constantly be adding new rows to each of the workbooks and with each new project I'll be adding new a new workbook to link to the master register. Is there a way I can link all these single workbooks to one file and have it so when I update one of them it updates the master one? If I add a row to one of these single workbooks will it automatically add a new row to the master file if they are connected?