Google Sheets importHTML help with indirect

[AustSportingPix]

Looking for ways to speed up my workflow and I found Google sheets "importHTML".
I've got it working with the website where I get most of my data from, but as the data gets added each day, there's a new webpage for this data.
The URL doesn't change much, its just part after the "Key=" (2021Nov06%2CVIC%2CFlemington)

=IMPORTHTML("Racing Australia | Horse Racing Results","table","3")

I've got a couple of drop down lists with all the data I need. These are cells M4 to M8
(M4: 2021
M5: Nov
M6: 06
M7: Vic
M8: Flemington)

The biggest problem I can see is the equals in the string.

Is there a way to do it?

I've shared the file

test

Sheet1 Race 1 https://www.racingaustralia.horse/FreeFields/Acceptances.aspx?Key=2021Nov06%2CVIC%2CFlemington Year,2021 Month,Nov Date,06 State,Vic Track,Flemington 12,<a href="https://www.racingaustralia.horse/FreeFields/Acceptances.aspx?Key=">https://www.racingaustralia.horse/FreeFields/Accepta...

docs.google.com

 

[jasonb75]

Is this what you're attempting to do? May or may not work in sheets, you shared your file as read only so I couldn't test it on there.

Book1
	M
4	2021
5	Nov
6	6
7	Vic
8	Flemington
9
10	Racing Australia | Horse Racing Results
Sheet1

Cell Formulas
Range	Formula
M10	M10	=HYPERLINK("https://www.racingaustralia.horse/FreeFields/Acceptances.aspx?Key="&M4&M5&TEXT(M6,"00")&"%2C"&M7&"$2C"&M8,"Racing Australia | Horse Racing Results")