Creating a summary page in excel

I have no idea where to start to create a summary page. I have two worksheets that contain data and I need to paste the entire row based on the value in a column F if it has any value other than 0 (zero). I don't know if it would be a formula or VBA?

I'm not quite sure what you are looking for but if it is sourcing the data from "Admin" & "Fac" then shouldn't be difficult - can you explain exactly what you are trying to do..is it adding, multiplying, subtracting (etc.) the data from the other worksheets?

What I'm looking for is to paste the entire row from Admin or Fac worksheet to the Pending worksheet based on if the pending amount in column (F) from Admin or Fac worksheets is anything except 0 (Zero). Positive or negative amounts. Not looking to do any calculations but just summarize or group on a different sheet. This is just a sample and each worksheet has about 200 rows. I am doing a table and grouping them but because the amounts can change on a daily basis, you have to go and resort cut and paste on a different sheet on a daily basis. Any help you can give me would be greatly appreciated.