I have a file which contains 3 worksheets. The problem I am having is
that every month I have had to highlight the 3 worksheets to change
the period i.e. from April to May. I use the replace function to do
this and this sometimes take too long.

What I am thinking now is inserting a 4th sheet and creating a list of
months From April to March so that once a month is selected the period
in the 3 worksheets will be authomatically replaced i.e. from April to
May. Has anyone got a better idea on how to do this using macro or any
other authomated means??


Many thanks in advance.