Consolidate, filter and copy data to another worksheet

[Dunagh]

Hello,

I have some workbooks with customer data. Their names can appear anywhere from three to four times with different monetary amounts per row. I need to add up the amounts per customer, filter out customers under a certain amount, and copy all the customer data, along with totals, to another worksheet. I would like to be able to do this with a function or macro so that it can be applied to different workbooks. My Excel coding skills are very week so hopefully someone here can help. Any help would be appreciated.

Thanks,

Rob