Urgnently i need a macro for adding footer to all existing sheets in
workbook and also to new sheets which is added

for example ther are two sheets named Yearly report, monthly report.
When I open this workbook i need to add a footer.also if i add a new
sheet called weekly report, then the footer has to come automatically.
Pls help me frends.Its urgent