Allowing users to add data to a workbook that uses Filter Function, which will re-sort with source

Hi all,   Really hoping someone can help - I haven't been able to find an answer online.    I have a "master" workbook, which for example, contains information for all ASM's customers. I then hav...