Macro & VBA: copy column formula over to next, searching for active cell

Attached I have a sample file of one of the three sheets I am updating and the other 2 sheets in pictures to show all I want in the macro to go through. Currently, I have 3 separate macros for each sheet, but wanted to just have one but i need help in searching for the active cell in dayschool to match the month text in the other sheets so once it matches the text it will make that the current cell and the offsets already in place for the macro to run smoothly. 

Look at active cells text value and match with each of the different sheets (in my case, months all in row 8 of the three sheets I am updating)

My file: Green- where cursor needs to be at to start new month update

             Yellow- ranges only needing to be updated

             Orange- output of macro, formula needs moved over for the month update