Duplicate legend and rename duplicated legend with sheet number

Welcome to the forum! This could help to get started: