Vba code for a sumif formula - place a new sheet

[OilEconomist]

Thanks in advance for your assistance, and I will let you know if this works.

Objective: To Sumif Column J based on Column A from Sheet 1 into Sheet 2, where not only are Columns J and A transferred, but the remaining columns are also.

Given:

-Sheet1:
--N rows x 10 Columns (Columns A through J)
--The number of rows will vary hence the N rows.
--The leading column (Column A/first column) contains a series of numbers stored as text values that need to remain text values.
--Column A is the basis of the sumif so it needs to be copied and pasted as column J has the values to be summed.

Sheet2:
-Empty Sheet with the exception of the heading being created/correct already.
--Destination for the SUMIF Formula
--It will need to contain all of the remaining columns which
--Column A – Column A from Sheet1 where the repeated numbers stored as texts need to be deleted so the SUMIF can be performed.
--The rest of the columns (Columns A through I) are identical with respect to column A, so column A in Sheet 2 can just look up the rest of the columns from Sheet 1.
--Column J =SUMIF(Sheet1!A:A,$A3,Sheet1!J:J)
--Finally sort Column J from greatest to smallest