Auto populate worksheet on selected columns with specific role

Hi i just wanted to get assitance.

What i wanted to do is, lets say i have a data from another source then once i pasted it to excel as "Value" on Sheet2 then Sheet1 one will show the only selected columns that i want but with a specific rule like IF Sheet2 column D has "SPONSOR" then Row Column A:C (Username, Firstname, Lastname) will be transfered to Sheet 1 Row Column A:C, but before it get transfered it will also check ROW COLUMN E if TRUE = transfer to sheet1 if False= will not be transfered to Sheet1.