Basic Cell Referencing - Return Correct Names And Values On Another Sheet?

Here's the data table being referenced

Rank
Week Ending
Name
Value

1
1/1
Apple
100

[Code] ........

Now on another sheet, I want to return the top two 'Name's and their values like below:

Name
Value

There is a fluctuating amount of rows in the first table, too. So what formula can I use to return the correct names and values on another sheet?

I'm thinking it will use some form of concatenate for the first and use a sumifs function for the value column..