Search files and copy with destination on file
 

I have a worksheet with the following:
ColumnA ColumnB ColumnC
*total*.* C:\douments c:\total_cost
*puchases*.* C:\douments c:\purchases_cost
*sales*.* C:\douments c:\salesl_cost.

What I want is a macro to search for the files(with the wildcard) in column
A in source folder (Column B) and copy all files found into destination
folder (column C). Kindly help !!!!!