It does not matter that they are not in the same row, I accounted for that, so leave as is.
If you want to use a separate macro for each sheet, use this,
And if you want one macro to do all the sheets use the code below.
But, there is one cavet, make sure the page layout is exactly the same. Eg, No spaces between groups,Have the group names start in A5. The size of the lists does not matter as the macro will tak care of that. My suggestion would be to copy the Daily sheet and then change all the contents to suit weekly/monthly data accordingly.
Bookmarks