Export Specific Cells/Data from Google Sheet to Excel Desktop using VBA

Hi everyone!

First, apologize because I have no basic about the VBA. But I need a code/script to solve my problem. My asking is quite long, but I try to make it as short as possible.

I want to copy the specific cells/data from Google Sheet to the Excel Desktop using VBA. Yes, Excel has a "Get Data" tool, but it could not paste the specific cell or data.

So, I found a code/script on the internet. However, as I declared earlier, I have no basic about VBA, and I am only able to change the link address and run the script/code. That's it.

I have several considerations about this task, but I plan to solve them one by one. Maybe other considerations can proceed if this post can be solved.

But for the time being, I need your help to:
1) Data from "Testing Spreadsheet" Sheet1 B3:C5 exported to the "Source.xlsm" Sheet1 B3:C5
2) Data from "Testing Spreadsheet" Sheet2 E3:F6 exported to the "Source.xlsm" Sheet2 E3:F6
3) Then, if we refresh or update the "Source.xlsm", the data can be replaced on the same cells.

I have uploaded an excel file, namely the "Source.xlsm", here. The Google Sheet link and VBA code in that file.

I appreciate any help you can provide. Thank you.

I haven't done this but look at this Youtube video using PowerQuery

Thank you for the reply sir. I realized that PowerQuery is come from "Get Data" tool. Ya, it is quite nice but this method will copy all data in the table. My objective is to copy & paste the specific cells from the spreadsheet to the specific cells in the excel, and not disturbing any existing cells in the excel sheet.

It maybe possible to use Selenium to get specific cells, however, it is very complicated and less reliable. I would just get workbook, transfer cells and close workbook.

I see. Ya, advanced coding or programming will make me a headache,
Thank you again sir for reply.