Me again.

I am trying to create a macro to create a chart as a new sheet. The
data I am charting is consistently in the same cells on multiple "data"
sheets. I am trying to create 1 chart per sheet.

I recorded a macro, and at this point:

Selection.Text = "='A-1 Data'!R4C5:R4C10"
ActiveChart.PlotArea.Select
With Selection.Border
.Weight = xlThin
.LineStyle = xlNone

I would like to be able to automatically refer to the sheet that was
active when the macro was started. I would also like for the chart
sheet to be automatically named as per the chart title.

Can the macro also give me a user input with GUI where I can select the
xls file in which I would like the chart to be created?

Am I dreaming?

Thanks
CaliberX