Create macro to copy data from rawdata file b

Hi experts...
Need a help from you to create an macro to copy the data from rawdata file by condition and paste it into another summary excell file.
My requirement is as under...
I have raw data file in which i have to filter for particular business group column by 3 different criteria like "GLOBAL OPS" then filter Region by "Asia" then filter by suppler name "aaaa","bbbb", "cccc" and then get the total USD value for this.. and then paste that into the summary file which has in one column soruced, vertical integration and in row i have 5 tabs under which i have to compare and paste the data from the raw data

itme supplir name spen(USD) source control region businessgroup
1 aaaa xxx CPCR america global ops
2 bbbb xxx CPCS europe infra
3 ccc xxx BMSD asia medical


AND THIS IS MY SUMMARY template FILE and need to copy that filteredd data from raw data and compare then paste it to this summary template under the respective subtotal, cpcr cpcs value fiel..

9 10
descriptopm Sub-Total % Not maintained CPCR CPCS BSCM BMDC EOL Wrong Category Can't Make VI has no capacity or price not competitive Category Changed Others
Outsourced(excluding of VI) $1,224,444 18.3% $0 $56 $99,999 $0 $0 $0 $0 $0 $0 $0 $0
VI $544,444 8.2% $0 $677 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total $6,677,777 100.0% $0 $888,888 $99,999 $0 $0 $0 $0 $0 $0 $0 $0
% 0.0% 19.1% 80.9% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%



It will be your great help if this macro done... i was doing this manually for one template, but i have more than 196 files to do the same by commodity wise..
please help

thanks a lot in advance