Format control data - values to be input differently on different tabs

Sounds as if you want all of your input to go into cells B3:C3 on the Holiday sheet and have to output (D3) sent to the appropriate month based on the format control value. Unfortunately, if my understanding is correct, I don't believe your goal can be accomplished using formulas. Although I am not knowledgeable of VBA I am doubtful of that also.
My suggestion is that you fill down columns B:D on the Holiday sheet and use the formulas from post #7 as modeled on attachment.