potentially long winded but...
Depending on whether the range is contiguous (ie
a4:d30) or broken into several little areas, and
presuming you just want the cell automatically
selected (no fancy "paste special" commands and
such), just use a macro and a form button:
Create your macro by recording as you highlight
cells or just write it - use
sub myrange()
Range("A1").Select
Range(""B4:c21,d4:f20"").Select
end sub
where all of the ranges are on the current sheet.
Now if you make twenty buttons on different sheets
you can assign the macro (myrange) to each with a
right click on the button itself. If you want a
button that selects these ranges on all relevant
sheets, use something like this as the first line
of the macro
Sheets(Array("Mon", "Tue", "Thu", "Fri")).Select
where the days are replaced with your desired
sheet names as they appear on the tabs in your
workbook.
Sorry if this is too simplistic or whatever, hope
it helped.