How to automatically copy and paste data

Hi

I have some data in cells A3:JN8 that gets added to daily so extending out to columns JO,JP,JQ etc on a daily basis.

What I want to do is copy and paste this data to another tab so I can 'transpose paste' the data and make it into a pivot table.

How can I have it so the data in the new tab will be automatically added to whenever I add new data in the original sheet into columns JO,JP and JQ and onwards?

Ideally I just want to press refresh and have the data there in an instant.

How would I do this?

I posted it in the original too but since that was in a different part of the forum I thought this question was different enough that it could be interesting for people in the 'excel general' forum

Any answers appreciated.

Thanks