Macro/VBA to automatically update one workbook from another separate workbook

Hi friends,

I'm quite the Excel noob but I'm working on a project that has 2 separate workbooks. One workbook is the project register, which has a list of all the projects the company has worked on by country name as well as project name and city name within that country. The second workbook is a cost database which is almost identical to the register, in that it has the country name, project name and city in the same order as the project register. The cost database also contains hyperlinks to different folders on the network with cost information specific to the country. Some cells in the database contain more than one hyperlink. I placed each hyperlink in textboxes so the row numbers in the database would correspond to those in the register. I'm trying to write a macro right such that there is a command button i placed in the register workbook called "Update". Basically what I would like to happen is that when a new row is inserted in the register (could be at the end or in between information since the register is alphabetical so if a new project comes up in a country starting with let's say H, when I insert a new row under for example row 25 in the H section in the register, a new row will appear in the database under row 25 in the H section), and the "Update" button is clicked, a new row would be inserted in the database workbook at the exact same location. It would be great if the information entered in the register workbook in the new row(s) would be updated in the database workbook too, but if that is too much, I just need the rows, so at least we can keep up with the new information in the database and will not have to go back to the register some time in the future and manually mass update it with all the new projects entered. Am I making sense? I literally have never coded a macro before, i don't know the language or syntax at all. ANY help would be appreciated. i tried fighting to write a piece of code but as expected it isn't working. I can post it also if that is necessary. Sorry this is so long!

Thanks!
Reesha

Ok I've attached a dummy register workbook. ignore the book 1

and here is the database dummy file with the hyperlinks

any ideas anybody?

I'm sorry. Apologies. :s

The register was created before the database and is already populated with information. The idea of linking the two together came only after the database had already been created and hyperlinks inserted. I know it would be SO much easier if they were in one workbook, that way I could just group the worksheets together and so when I insert a new row into the register when a new project comes up, it would automatically insert in the same location in the database, but my hands are tied. I have two separate workbooks that need to be linked somehow and I don't know how :/

Is it okay if bump now? No ideas anybody?

Because I think they wanted just the register list separate from the cost database information. Plus the cost database information won't be updated as regularly as the register list. But they didn't want someone to have to go back in after 3 months and compare the register with the database and update the database from there. That's why I was asking if there was any way to sort of group the two workbooks so that when the register is updated with new project information, the cost database will also be updated with project information. That way when it becomes time to update the database with cost information, the project information would already be there so all the person would need to do is follow the project information to the respective folders on the system and find cost information and put it into the database. Am i making sense?