Copying filtered data

I have a spreadsheet with mutiple columns that I am filtering on the "Assign" field. I can write the macros for the filtering but am stuck with copying the data. My problem, I only want to copy the data in columns A, B and C for all visible rows and paste it onto the corresponding sheet with the Assign name in cell A20. I don't need any of the data from columns D through to O and I cannot delete those columns from the main sheet. Once the data is copied over to the other sheet, I want to delete the filtered data from the main sheet (SCHEDULE) so I don't have to see it again. Based on the sample I am providing, need to filter for all Assign = Sam B, copy data to tab Sam B, delete data once copied over. I have searched but could not find anything specific to what I need. Any help would be appreciated. Working in Excel 2003