I have a spreadsheet with multiple sheets. One of the sheets has historical
data that I update daily. I use this to create graphs and correlation
matrices and such. Right now I have all of my other sheets linked mostly to
the first 40 days of the historical data. What I would like to do is create a
macro that I could either enter a date range into or an amount of days into
an input cell and then have that form the input data that goes into the
graphs, matrices, etc.

For example, instead of being able to only look at the first 40 days of data
in a graph, I would like to look at the data for last June through August. Or
if that is not possible, I would like to pull data from the most recent date
to 80 days past, or 120 days past, for example. And I would like to do this
by simply changing an input cell(s).

Is this possible at all? And if so, could you give me a general idea of how
to go about it? Where can I look to find out how to do this?

Thanks,
Darren