I have some charts that need weekly update, is there a way for me to update
these charts automatically across sheets in my workbook - Whenever new rows
of information are entered in my table.

I normally drag the old reference cells to the new cells to get the chart
updated. If anyone can help me I will be totally grateful.

Thanks a lot.