Setting a file location within VBA coding

Hello All,

I've been given some help auto-populating information from individual forms into a separate summary sheet using a macro. However, at present, it defaults the workbook open element to my Documents as opposed to the location of where the forms will be saved. Can anyone me insert a file location within the following:

Please Login or Register  to view this content.

I initially had the following tool, however, my limited experience of macros means I'm unable to fit it into the logic.

Please Login or Register  to view this content.

Thanks!