I have 3 worksheets that are linked to a file somewhere on the network
drive. The 3 worksheets contain period name i.e. May which I would
like to change everymonth. Currently I highlight the 3 worksheets and
use the replace function to change the period every month i.e. from
April to May.

As this procedure sometimes take too long, Iam thinking of creating a
month list on a separate worksheet and thinking that once a month is
selected it would authomatically replaces the month in the 3
worksheets. Has anyone got an ideal how this may work using macro or
any authomated form?

Many thanks in advance.