Conditional Copy and Paste

Hello,

I have multi sets of data spray on more than 3000 rows between column A to N. Each set of data start with the wording “BEG“ and following by 8 digits. This wording is located on column C.

I would likes to copy each set of data that start with the word "BEG" and paste on a new sheet and name the new sheet base on the last 8 digits that follow the word “BEG”.

Best regards to all,

No one have any idea?