Automatically Update an Excel Chart Title

[Grover]

Hoping someone can help
I understand how to make a chart title dynamic.
What I want to be able to do is

Have a chart title automatically update from a different cell each day
I have over 100 charts and at the moment it is fine until on any given day in a month the title needs to change
This involves referencing a new cell for each title
Is there a way that the title can automatically reference a cell on the current date and change automatically?

Help very much appreciated
I'm not an expert but intermediate at best

Thanks

 

[mole999]

so your chart title is say A1 with =A1
how about you make A1 update with a formula to follow your data, then the link will always be the same

 

[Grover]

so your chart title is say A1 with =A1
how about you make A1 update with a formula to follow your data, then the link will always be the same

So the whole thing is quite complicated
Basically there is a master sheet that each day has 40 rows for different items that is updated by a production group
This in turn then migrates to another worksheet that generates some production metrics
The identity of the equipment is taken from another sheet via VLOOKUP
The information gathered is then relayed to a cell that forms the chart title
However each day the master sheet is updated then populates a new worksheet, I.e a worksheet for each day of the month
So the title can change dependant on the equipment selected
So 1st May for example can be xxxx
3rd May can be YYYY
The chart can be filtered to ensure the information for 1st and 3rd May can be distinguished but the chart title is taken from say 1st May worksheet
If on 3rd May the equipment changes I have to go in and reference the cell in 3rd May to change chart title
What would be great is the chart title references the master list and changes with each day

Sorry i know that sounds confusing
Also the cell the title is taken from combines information from more than one cell

 

[Grover]

Can anyone help with this please.
So basically a dynamic chart title that updates from a different cell every day
Thanks