Cutting pasting data to an existing template
 

Hi guys

Every month a receive 100 or so reports from a supplier which, at the
moment, I strip off their headers and place a new picture banner (to rebrand
the report to ourselves) and send out to different people. As you can
imagine laborious to say the least. I have tried recording macros but
clearly my VB skills have a lot to be desired.

The files that are sent in are not named consistently and I need to save
them by their client name and date (always in specific cells).

I need to automate the stripping out of their banner and replacing with
ours. Would it be easier to open a template with our branding already on it,
click a macro button to import the cells from say row 4 onwards and
automatically save as per the client name in E5 and the month E6.

Thanks guys for your help