Macro Help- Copy, Analyze, Create Graph

Hello,

I'm trying to write a macro that will take an xls file that has only one sheet, create a second worksheet within the excel file, copy and paste (but not delete) a selected range of data from the first worksheet into A1 of the second (by calling the range for the range to be copied via the text that is in the cell, not by the cell location), analyze the data in the second worksheet, and create a line graph as a new sheet.

So essentially picture the original xls file having a ton of data on sheet one but because the data varies month to month but the headers of the range that I need copied doesn't, I want to call it based off the data header so it can be consistently used.

I'm so lost-

Thanks