How to import excel specific data to a new workbook

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.

Thank you for your prompt reply:

This is what I did.
I create a new workbook and put the heading on it. Then, I copy the code you sent on sheet1 and save it with macro on it. The file extension is .xlsm.
Now I have a form where the imported data (copied data from F7:M15000) will be stored.
I click ctrl+g and I got a new window that display “Go to:” and then the cursor is blinking on the box marked “Reference”.

What is lacking? Should I put the code on “thisworkbook”?

I only want to copy values from F7:M15000 to this new workbook.

Thank you.

Thank you, it works; but the whole workbook with multiple sheet is copied to a new workbook NOT to the workbook that has a VBA code on it.

What I want is to copy only data from F7:M15000 to the workbook that has the VBA code and paste only the values (without the formulas). Every time I will open this workbook, I will just hit SHIFT+CTRL+G and to automatically update this workbook.

HOW IT WILL WORK:
Open the file that has the VBA code.
Once the file is opened, Hit the assigned key (SHIFT+CTRL+G) to copy the updated data file (F7:M15000). This will be the process everyday.