I am creating a generic form in Excel that will contain information about contracts to 3rd parties. There will end up being a fair number of these forms. There will also be a master document that contains summary information. I need to make as many fields on both of these forms as locked as I can to most users.

Basically, I need a way to populate the master with that summary information with a hyperlink to the individual file.

Of the options I can think of:

1. A button on the individual file to "Export Data", which would populate the needed information into the Master Log at the end of the list with a hyperlink in the first column. The hyperlink would need to be renamable to something short. There would need to be a check to make sure that it hasn't already been uploaded.

or

2. A field in the Master Log that allows a user to upload a hyperlink at the bottom of a list along with data pulled from the newly created hyperlink.

For whichever method actually works, I would need the formatting of the list in the master log to be pulled down because some calculations are made there as well. Although I may be able to get around this if needed.

In terms of my abilities with this process, I am like a child who grows up learning to understand a language but not speak it. I can sometimes follow what people are talking about when writing macros and whatnot, but I don't really know how to make things work together.

I appreciate any help that can be given. Thanks!