I have a series of over a hundred text files in a single folder, all of the same format. I have a spreadsheet that uses "Get & Transform Data From Text/CSV" to select one of them and insert its contents into the range of cells A1:C20000.

Normally you can change which file is loaded by going through Queries & Connections, or various other GUI elements. But I want the user to be able to simply type the desired filename into cell H6, and it will change which file is loaded into A1:C20000.

Is this possible?