Create macro on one sheet to update on another sheet

Hello,

Trying to create a macro that will update data onto another sheet. Further this other sheet will be spending on the file path that the user selects, such as their city. Example would be the Hartford buyer will input Hartford into a cell, the macro will find the shared folder Hartford.xlsm and it will imprint the correct information for me. Each day the buyer will hit the send button and it will send me the correct information. So I'm looking to create a macro that will allow a user to type in their city, type in the date and then save information onto a separate sheet in the appopriate spots. There are 6 items that I would want saved