VBA assistance for copy and paste-special values into specific cells and only blank rows

Please see attached sample/test file.
Using Office 365 Excel

I recorded a macro (which is the only way I know how to get VBA code).

This macro is then assigned to the button at the top of tab "Log" (says "ONLY Press..."). I do want to keep the button to execute this code.

When this button is pressed here's what I'm trying to get it to do:
1. Do not RUN/UPDATE anything if there aren't any blank records in Columns K & L (K & L will always have data whereas columns L-AN may or may not have data). Warn and tell the user with a pop-up that nothing was updated. Give user a button to click OK to close this pop-up window.
2. The User will input a date range (can be the same date) into cells C1-C2. This will refresh a query on the tab "DataLookup" which will load the data that will be needed for the tab "Log".
3. The User will then input a few records (could be 1 record, could be 5 or more, but normal is none or 1-3 per day) into the next empty row on the table (tbl_Log) found on the tab "Log". I've input "9" and "10" in column A to simulate 2 entries a user might do.
4. Once the user has input the info in the blue section (Columns A-I), they will then press the BUTTON at the top (shown in Columns J-M)
5. This button will then do the following...

As mentioned above, it may do nothing and tell the user nothing was updated (i.e. say the user hits the button but hasn't added any new records).
In most cases, the user will correctly make a new entry (like 9 & 10 in Column A in this example) and when they press this macro button...

a. The vlookup formulas on tab "Lists" in Cells Q9-AT9 (which is also a named range called "rng_Vlookups") will be copied into all empty rows where Column K is empty on tab "Log".
[On the tab "Lists", cell S4, I have a basic formula to count the # of empty cells and therefore the # of rows that the vlookup formulas need to be copied into, in this case it would be copied to cells K14-AN15. I was thinking that this simple count could somehow be used to determine how many rows/records are needed for the vlookup formulas to be copied?]
b. Once copied, the macro will then do a Copy>Paste-Special Values so that the data pulled into cells K14-AN15 will be hard-coded.
c. Then I need the macro to hit "ESC" to get out of Copy/Paste mode (so that the cells are no longer highlighted/encapsulated by the dash lines)
d. Then have the macro hit "Home" so that the user is returned to the far left side of the screen (doesn't matter to me if they end up on row 14 or 15 or 16, just as long as we throw them to the far left so it's basically ready for new entries tomorrow.
e. If you can tell the user how many records had data imported that would be great.

You CAN press the button to see at least what I'm attempting to have done.

Appreciate any assistance with how to make this work efficiently!!!

Sorry this is confusing. It's difficult to explain every detail and how we use this data.

But I'll try to expand a bit more.

Old way:
User would manually input all data elements. Literally everything we want to track and then report on would be manually entered.

New way/goal of this:
User would input value into Column A (along with some manual notes and other entries into Columns B-I).
But now I want to pull in the additional data and not manually add it. Pulling it in, from another query, then hard-code it so the query on the tab "DataLookup" doesn't get too large (because it could contain 100,000 or more rows and with 30 columns of vlookups Excel gets too slow (so hard-code it and save the data static on the day we log an error).

Additional data pulls from the tab "DataLookup" which is refreshed by the Start (cell C1) and End (cell C2) dates found on the Log tab. When these change the DataLookup tab refreshes to pull in the various data attributes from our internal table/warehouse. I then need to pull this data over to the Log when a user input their Value into Column A. DataLookup will have, on average, 200-400 records per day when refreshed. User will only input 0, 1 maybe 5 records per day where an error was discovered from a completely separate report. They log the Application# (in column A on tab "Log", make some notes, and the vlookups copy into Columns K-AN and then we hard-copy/paste-special the values so these values are stored forever (because the next day the DataLookup tab will pull in the next business days' activitiy).

Vlookups are in the tab "Lists" and have a named range called "rng_Vlookups". There are 30 vlookup formulas found in cells Q9-AT9 that are 1 in the same as the named range "rng_Vlookups". These are the fomulas I'm looking to copy over to the tab "Log", into new rows, Column K-AN.

New rows are manually added each day by a human from another report/file (not contained within this file), The user puts these on the tab "Log" by adding in row 14 for example the "9" in Column A. Then "10" in row 15 and so on. These aren't the real numbers of course.

I'm not looking to clear anything, this is a running log.

Sounds good. Back to basics:
1. The object is to copy the vlookup formulas (from tab "Lists", cells Q9-AT9, also a defined named range "rng_Vlookups") into the blank rows starting at column K on tab "Log" so that the data from tab "DataLookup" will be LOOKED UP and shown on the Log tab and then that recently copied data can be pasted-special-values to save it forever without the need to have vlookup formulas sitting there. The DataLookup tab will change what data is available is the reason we need to hard-copy and save the data without the vlookup formulas.
2. That is correct
3. Newly added rows: the user manually inputs data in a new row starting in Column A and doesn't go past Column I. Column K will always be blank before we copy/paste in the data. Column K will NOT always be the first blank column in the data set (for example, in my attached sample file column F, G, H and I can be blank at any time). But Column K will always be our starting point to copy in the Vlookup formulas.
4. I'm no good with the Offset function. I can only say that the formulas in Q9:AT9 work just fine, refer to the tbl_Log and the Column Headings, and pull the position number correctly as I have them setup. I'm assuming you or someone may have a better way to do this, but I'm a novice at all of this so I'm currently using/doing what I know
5. Keep in mind this is just a sample/test file. The tab "DataLookup" is refreshed each morning with a new set of data containing 100's or 1000's of rows. The lookup cell will move. I'm only aware of using Vlookup to find the appropriate match.

I'll add a bit more info: New rows/entries start in Column A. The Log tab is a table called "tbl_Log" so when the user inputs a New Entry into cell A14 for example (which I've input the entry already as "9" in Cell A14 just for this test so you can see the empty cells K14:AN14). New entries cause the table to automatically grow. If you were to input "11" into cell A16 for example, the table "tbl_Log" would "grow" by 1 row and now have cells K16:AN16 needing data copied in too. Add 11 for fun and now we have 3 new entries...9, 10, and 11. It's these 3 new entries that I need the vlookup formulas to pull the corresponding data from the tab "DataLookup". Once the Vlookups are copied into the 3 new entries/rows (starting at K14), then we need to paste-special the values so the data is retained forever. Rows 6-13 already have the data pasted-special-value already completed and are good as-is and should not change or ever update (i.e. hard-coded and saved forever)

Checking to see if anyone has a way for me to accomplish what I'm trying to do here. Appreciate any help on how to code this. Thank you