Good Day Lads and Ladettes!

Not sure if this should be tackled with a macro or not but I figured it could probably be done without it.

I'm a project document controller. I have multiple document registers in excel (all with the exact same format and columns) one for each individual project.

What I want to do is create a master document register that gets updated automatically. For example I might add a new row with all the document details to a specific project document register and it would automatically add that row to my master document register. It would be the same format and columns as all the others but it would just allow me to hold all the information in one place.

Would this be difficult to achieve?

Many Thanks,

R