Copy paste data from working files to new workbook for each customer

Hi Guys,

I am very new to VBA and Macro world and I hope I can get some assistance from you guys.

Here is the thing, I have a master file with customer data (customer number, customer name, items for each customers ...etc).
I need to filter on the customer number column, copy paste the customer number into a new workbook (cell F1), copy paste the customer name (cell B2) into this new workbook and finally copy paste the list of items (starting from row 3, column A).
I have more than 400 customers, I need to create a new workbook with these information for each customer.
I tried to record a macro but keeps giving me "error 9" ...

Any help will be much appreciated ! If you require more information please don't hesitate to ask !

Thanks guys !

title updated...