I need HELP for a VBA code to import excel data from a shared drive (open or closed) into my work station (new workbook). Please help.

Here is the scenario:
Location of file to import : Drive Z
Name of Workbook/file : Locator.xlsb
Name of Sheet to import : Data (The workbook has a multiple sheet and only this sheet will be imported to a workbook; all other sheet will not be imported)
Condition of Sheet : Locked
Cells to Import : F7:M15000
Condition of Cells : Some are locked
: Table formatted

Imported File to a formatted workbook
• Imported file should start from cell A7
• Import values only
• Assign a function key to RUN the import after opening the formatted workbook (or any suggested means)


Thank you and hope to received positive response ASAP.