Automatically update a cell from a range of cells

[Grover]

Hi
Can someone help with how to have a single cell automatically update daily from a range. So i have a worksheet for each day of the month and the equipment used can change daily. Currently the identification of the equipment is taken from multiple cells
My issue is this then forms a dynamic chart title that can only be changed manually. Thoughts are if i have one cell that automatically updates from these each day of the month cell i can link my chart title to the individual cell
Thanks

 

[DSCfromCFA]

G'day Grover,

A few questions:
1. is there a separate chart for each day, or one chart that gets updated each day with links to the new days information?
2. How many different pieces of equipment are there and how are they laid out in the daily worksheets?
3. How many different pieces can be used each day which would form the chart title?
4. What is the format of the title that you want to achieve?
5. VBA or Functions?

Cheers

shane