Copy selected range with charts with relative reference 800 times

Guys,
I have come across a problem that is harder than I tought.

I have a sheet where I enter a lot of data. I will enter same set of data approx. 800 times. The problem is, I need to have several charts for each data entry.

As we all know, charts use absolute referencing, so I just cannot edit SERIES function neither use INDIRECT function.

So I guess the only way how to do it is via VBA. And thats where excel gurus come in

Any tips?

I would also need a button, that when being hit, ads data entry cells to the very end of the sheet after the last data entry

See the attached file...