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 s...