Excel, VBA, Macro Pivot Table & Chart

From CCM Master file. I want to copy some data based on criteria in new file which should be done by button. I want to assign macro & button in seperate file. SampleBoard_CCM sheet I want to copy some data in other sheet using VBA and assign macro to button Column M - criteria PPAP status is blank than copy those rows and only Columns A,B,E,F,G,I,M,O,P,Q,R,U,V in new sheet Also I want to assign Pivot Table & Pivot Charts VBA coding and assign to new button. Also I want butons for create data based on customer name, Part no. When we click on button it will ask us for customer name / part no.