How to split worksheet into multiple worksheets based on column content

I'm trying to break up a worksheet into several worksheets based on the data in the "branch" column.
I've tried to use other codes posted here, but, I can't seem to nail down the debug process and accurately identify the cells/columns that I need.
I have a header row of 7 columns:
member_id nps comments additional_comments Call Me! Number Branch

the data in the "branch" column is the one I need to be the defining one for creating the new worksheets. How do I modify/create the module code?