Hi! Im currently working on a sheet that uses =IMPORTHTML to grab a table from a website which posts two versions of that table daily, on separate webpages, where the URL follows this format
https://www.xxxxxxxxx.com/xxxxxxxx/xxxxxx-xxxxxx-YY-2025-01-20#xxxx
I would like to write an expression that lets me change the date moving in either direction (both to get previous dates and dates as they come). I'm struggling finding a good way to do this. This I keep on Sheet 1.
I grab a table from each site and store them on Sheet 2. Is there a way to automate this? because they contain a different amount of rows, it seems


![[WDYWT] Yo listen up here’s the story](https://i.redd.it/x73m9jlgosx21.jpg)
![[WDYWT] dont forget your potholderz](https://i.redd.it/sbg6vy3bqin21.jpg)