As im starting to move more towards Macro's and commands that ultimatly are
more useful than normal formulas in cells, I find myself needing to know
something about VBA.

Currently I want to press a button have some information copied to a certain
cell dependant on today's date, but I have no idea how to get it to look at
cell D23 if cell H41 has 23 in it. Also I will need the sheet to have a
button that opens a sheet and copies some information from it, the only
trouble with this is that the file that needs opening will be a different
name each day....

It all generally leads me to wanting to know more about VBA, my general
coding experience is low, and most of the stuff in VBA looks like a load of
random characters to me.

Are there any books/websites that can help me get to grips to having VBA do
what I want? I learn't most of what I do in excel by having a look at the
functions and their helpfiles.