The attached contains a Power Query offering, but because it doesn't know where to find the .csv file on your system it will need to be tweaked on a once-only basis:
On opening the file, go to the Data tab of the ribbon and click on Refresh All in the Queries & Connection section. (You could just as easily click on the command button, but you'll get a vba error too, which you'll have to End)
Either way, it will complain, so then:
On the Data tab of the ribbon, in the Queries & Connections section, click on the Queries & Connections icon. This will open a pane on the right. Choose the Queries at the top if it's not already selected. You should then see Input 'Download did not complete'.
Right-click Input and choose Edit… This will open the Power Query editor.
On the right hand side you'll see an area Applied Steps, and below that a series of several steps. (You can click on these to see what's going on.)
Next, on the Home tab of the menu, in the Query section, click Refresh Preview. It will complain with a yellow band. Click on the Source step on the right and you'll see a button: Edit Settings: Click it. It will allow you to browse to the Input.csv file (or whatever you've called it) on your system, then click OK.
The query should now work. (If you click on the last step, Changed Type with Locale, you should see the final table.)
All you need to do now is to Close & Load which is at the extreme left of the Editor's ribbon's Home tab. The data should refresh automatically, if not, click your command button.
I've used cell K2 instead of 'A1 on another sheet'. K2 is a named range Symbol which can be anywhere in the workbook which means you can delete that named range and create a new one of the same name wherever you want (except within the result table!) If you choose to make the named range bigger than one cell, it's the top left cell of that range's value which will be taken.
So the procedure's like this: change the value in K2, click the command button.
You don't actually need a command button or vba (it's only one line), you could either click the Refresh All button in the ribbon as indicated earlier, or you can right-click the result table and choose Refresh.