Move Data From One Tab To Another

Hello,

I am not familiar with how to write macros so I am hoping someone can help me. I have data on one tab in numerous columns, the number of rows will vary. Each row of data on this tab will be categorized into Class A and Class B based on the selection in one of the columns. I want to create a macro that will move each row of data to another tab and separate Class A from Class B while summing the different columns of data, while preserving the column headings. Can someone help? Thanks!