Hello mastah, anyone help me for my problem?

I have 2 tables in 2 sheets like this pitcure :
2015-03-12_214135.jpg
there are 2 sheets : input and output that have unit name table : A, B, C. and I wanna filter the unit name.

I wanna make vba to create new sheets be like this pitcure :
2015-03-12_214423.jpg
then it will be make new sheets: sheet A, sheet B, sheet C, and sheet ALL.

anyone help please. I attached the sample sheet example.xlsx

many thanks to you all