Filter then paste to multiple workbooks

Hi folks.

Apologies for what looks like a loooong request! please bear with me

I have a fairly large data set (circa 20,000 rows) containing daily sales info for company nationwide. There is info in columns A – N (with headings in first row)

In column D there is branch location. I need to divide the info up by branch, and then copy the data from each branch into a pre-designed template for each branch – so any info for Edinburgh will be pasted into ‘C:\andy\branchtest\edinburgh’, and any info for London will go to c:\andy\branchtest\london , and so on and so on.
The format of the destination sheets will be exactly the same as the Source sheet and the headings will be the same.
This is a daily task and the code does not need to find ‘next available cell’ as pasted info in branch templates will always start in cell A5.

Can anyone suggest the best way to go about this please? Any advice/suggestions appreciated.
Cheers

try this macro with a small extract of data e.g. given below
h1 h2 h3 h4
61 45 36 a
49 37 30 s
2 78 85 d
26 74 17 s
84 82 53 a
81 8 36 s
22 28 40 d

replace column D that a,s,d etc by your names

the macro should be copied in module of this workbook

if this is successful you can try with the original data. But I am afraid it will take time
you can modify it if you like.

I am not able to check the macro completely