Yes it can, you create it like a formula using IF THEN ELSE statements, checking for the current MONTH, not the day.
Read up your Excel Help documentation on this, the usage is there along with an example which you can paste into your macro area then adapt.
I'll give you a tip - don't tell it to go to a sheet by name, tell it to go there by worksheet number. Each worksheet has a reference number Excel uses to identify its location, basically numbering 1, 2, 3 etc from left to right along the tabline.
So example refer to the sheet as worksheets(1) instead of worksheets("sheet 1"). Using the number instead of the name means even if you change the sheet names after the macro is crated, the macro will still find the right one by its location along the tabline.
As for what you said about VB script, Excel doesn't use VB script. It uses a flavour of it called Visual Basic for Applications, and seriously no programming skills are needed until you get into the really intense stuff.
Again, whenever you need a macro you can't figure out, always search the Help files in Excel first (highlight the expression then press F1 for help on it), as the documentation is actually really good.
