VBA to create custom headers for certain worksheets in a workbook

Hi,

I'd like to create custom headers for certain worksheets in my workbook. They will need to be a mix of text and a date reference from a cell in the workbook. The worksheets are called:

• Spend

• Savings

• Sector

• Customer & Supplier

• MI

The first text element will be "Performance Report".

The date (located in a tab called 'Lookup', cell C19, that has a named range of 'Lookup.MonthSelected') is input in the format xx/xx/xxxx. I'd like it to show in the header in the format mmmm yyyy.

The last text element will be as follows in relation to the list above.

• "- Spend Analysis"

• "- Savings Position"

• "- Sector Analysis"

• "- Customer & Supplier Analysis"

• "- MI Position"

For example, the header for the 'Spend' tab will be 'Performance Report November 2016 (or whatever date is selected in Lookup!C19) - Spend Analysis'

Thanks in advance,

Snook