I think most of what you want to do is possible.. just trying to understand exactly what that is, that's the hard part..

Your best bet would be to attach the 'actual' destination Workbook you are using (including the chart etc), and attach again your exampledata workbook.

Changing header values can be coded for and sounds like your broken chart might be fixed using dynamic ranges or something like that.. don't give up.