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?