Multiple text sheets into a master worksheet as you enter data

[Tribe Crazy]

I have several text worksheets within a folder. As I enter text into each
worksheet, I want the same text data to feed into a master worksheet in
another workbook, where I can autofilter the text info. How do I do this?