copying over large data set from a different sheet.

"I need help with a formula that will copy all the data from sheet 2 to 1. this is a smaller size but it is for 50 points.
Initially I used a simple copy over but since I have more to copy over and sometimes I am missing 4 what should I use"

I use VBA code to get the data in column.

After that a table.

After that a pivot table.

See the attached file.