Combine Strings from Multiple Sheets without duplicates

Hello, I'm hoping someone can help me solve this issue as I can't seem to figure it out if its even possible.

I'm trying to create an Excel Sheet that will store information about archived data stored across multiple hard drives.

I have 3 sheets. (Main, Drive A, Drive B)

I have one column in both Drive A and Drive B called Name.

Drive A has File 1, File 2, File 3 listed in the Name Column,

Drive B has File 2, File 3, File 4 listed in the Name Column.

I want my main sheet to have a column called Name that pulls the information from both sheets and removes any duplicates.

So Main sheet would say

Name
File 1
File 2
File 3
File 4

I've tried doing this using Consolidate but the issue is when I add a new File to either Drive sheets I have to ReConsolidate every time. I want it to be automatic.

I would also like it sorted alphabetically automatically.

Is this possible? I would appreciate any help. Thanks!