Macro which will filter and paste data to new worksheet

Hi,

I need some help with a VBA code as I have no experience with writing a macro.

I have an unsorted data sheet which I need to extract information from and with each data extract I need it to create and save a new workbook.
1. On the tab GL – Column A I have a branch code consisting of 3 digits. What I need is a macro which creates a new workbook splitting out each branch.

e.g. in the example supplied I would like 5 new worksheets created showing data for branch 181 on one work sheet, 182 on another, 183 on another etc etc

2. For each new worksheet am I able to define the worksheet name – ideally I would like the branch name e.g. “181”

3. Is there any way in which I can define the workbook name and location to save to (if it doesn’t exist I would like it created).

I know this is a big ask – if there is a similar workbook that exists that I can copy the logic that you know of please point me in the right direction.

Any help is appreciated.

Paul