Macros/VBA

Hi,

I'm trying to add 2 different cells in a work sheet to the header in a new worksheet. Then I need to excel to save the new worksheet as a new file name which is named in worksheet 1.

Any ideas?

Thanks in advance,
Tanner