Having problem with autofilter vba

Hi everyone,
I have a little knowledge about vba.I have made a workbook for my work,everything is working correctly except the two macros I entered at the end they autofilter data & copy & paste specific rows to sheets.I don't know what I have done wrong ,when I ran macro it disturbed my data sheet.
Can someone help me please,is there any other easy way to solve my problem,if someone make it decent looking I will be grateful to him because stock sheets,sell sheets & customers sheets should be differentiate easily.