Reza Rad of Radacad posted a video on how to use Parameters in conjunction with Power Query to import data easily. In this example, he shows how to scrape many years of holiday dates from a website by declaring the range of years he desires.

This is an advanced technique, but well worth your time to learn if you are a beginner.