File Organization For Final Cut Pro

Hello Everyone, Hope You All are well. I have previously asked before, but I want to refresh my memory, and possibly see if there are new techniques.

I have an M1 Max MacBook Pro. I make Travel and Lifestyles Vlogs, and edit with Final Cut Pro. I am behind on video editing, and have several vlogs from 2014 onwards that need to be edited. I have at least 6 external hard drives with the footage. On each external hard drive, I have made a separate folder, and have copied the videos to the individual folder. So essentially, there would be 6 or so folders with videos.

I would like all the videos to be on 1 or 2 external hard drives, so everything is better organized. Since videos may be part of a folder (for previous organization), within each folder (that contains all the copied videos), I will go via finder and search .mov (or any other video formats), and copy over all the videos to a new external hard drive. This will allow only videos to be copied (and no folders), and all the videos will be together. Once the process is complete, I can sort by Date, and organize videos as needed in a folder system.

The issue is that the individual folder on each external hard drive that contains the videos that I will transfer to the new external hard drive may have duplicate videos (duplicate videos may also be on more than 1 external hard drive as well).

How can I ensure that only a single version of the video gets copied over? I also want to make sure that if a video is already transferred on the new external hard drive, I would not want a duplicate to get on the new external hard drive. My concern is also with different file names, like when “copy” or different numbers are used for duplicate videos. Will the system know a video is a duplicate, even with a variant file name? Also, if 2 videos have the same file name, but are different, will the system treat them as different videos?

The moment the system senses a duplicate video, it prompts if You would like to stop, skip, etc. If I click on skip, would it skip all the duplicates (and do what I want), and only transfer single versions (regardless of whether they are on the starting external hard drive or destination external hard drive)?

I just want the easiest way to go through the process before editing again. I do not want to do anything with scripts/terminal.

Can this even be done?

I would really appreciate any assistance. Thank You.