Filtering, copying and pasting specific values in different tabs in same spread

[Exceliscool123456789]

How do I create a macro that will filter for 3 specific values in a spreadsheet and based upon that value will copy and paste that information into different tabs in the same spreadsheet underneath the last row of data in each tab between certain date parameters? Let me know if clarification is needed?

 

[Exceliscool123456789]

Hello, any assistance would be greatly appreciated.