Sample.jpg

I have two sheets, sheet 1 is where I paste data from external source, sheet 2 is where i calculate and summarize data,

Problem 1:

Column B, i would like to return the accounts from sheet 1 row 2. i use =Sheet1!C2 but when i drag it down it the formula becomes c3, c4... when i need d4, f4...

Problem 2:

in sheet 2 i column c I use a sumif function =SUMIF(Sheet1!$A:$A,Sheet2!C1,Sheet1!C:C) to return all data A in COLUMN A of sheet 1 under account 1.

is there a way to match column b and row 1 of sheet 2 to get the details in sheet 1?