How vba macro can get reference from cell

Hey there guys !
I am a beginner in excel, but i am really curious, so I am learning and trying things as i need...
Here is my question:

I am developing this project where i have the hours of my workers throughout the whole year. The tables are splitted in weeks, so I have 50+ tables.
I created this macro that selects all the areas I want to clear, but if I want to clear data from the next table, I have to make another macro just for the next table ... and so on and so on ...

Here is the macro :

Sub DeleteValues()
'
' DeleteValues Macro
'

'
ActiveWindow.SmallScroll Down:=12
Range("D47:R61").Select
ActiveWindow.SmallScroll Down:=12
Range("D47:R61,E69:F74,Y47:AL61").Select
Range("Y47").Activate
Selection.ClearContents
End Sub

Lets say for the range If I have something like "Range ("=B23") and on the cell B23 I will show a value like: "D47:R61,E69:F74 ..."

So on the B23 I would actually have a list of all the ranges values I would like to select and then i would run the macro ...

Does that make any sense ?
Do u guys have any other alternative ?!

Thank you very much in advance ,

Thiago Neves

Here is the start of the project, it still a little messy though ...
Thanks

Really nobody could give me a heads up ?!