Drop down list range - how to change each month quickly with VBA?

Hi, I produce a report at the beginning of each month and there are 30 worksheets in the report. The report has a drop down box on each worksheet allowing the user to select the month of data they wish to see. The problem I have is that each month I have to extend the data validation range on each worksheet by one row (to show the additional month, i.e on Sheet1 which is a hidden sheet i have listed Jan, Feb, Mar, April, May, June, July etc on each row and each drop down box refers to this range) - it takes me a long time to do this for every worksheet and each drop down box. is there a quick way to do this?

If you make your data range for the dropdown list a table (Assuming Excel 2010 or after; previously, I think it was called a list) then it will extend automatically as you add more data to the bottom of the list.

a dynamic range did the job! thx for the advice
this has saved me a lot of time changing each drop down range