VBA Code to Change Chart Range based on new row number count

Hi - Hope I can explain my problem easily enough.

Sheet 1 has a chart, the chart range is (currently pre-defined) as Sheet 3 range $B$3:$X$26. This has lots of data and formulas from other sheets.
Data is input onto Sheet 2, with a row counter (Sheet 2, $C$75) currently at 24. Sheet 3 grabs the data from Sheet 2 and updates all the info based on Sheet 2 (and others).
When new data is added on Sheet 2, the row counter adds it.

I need a VBA code so that when I add data to Sheet 2 (and the counter moves from 24 to 25), then the range of the Chart on Sheet 1 must automatically update to Sheet 3, $B$3:$X$27.

I hope I am making sense.
Thanks.

Hi. Thanks for the response.
I have investigated tables, Pivot Tables, etc, and also dynamic named ranges, extensively.
Because of the "extreme complexity" of my workbook (over 50 sheets, in excess of 4.5 MB), and extremely complex formulas and references, these methods don't seem to work.
Given a lot of thought into it, and a VBA code changing the range based on a simple number (count of rows) is the simplest method.
Thanks all the same.