Hello, I am new to working with VBA/Macros generally, and working in Excel 2204 I am looking to create a Master Spreadsheet that automatically will populate existing AND newly entered data into worksheets sheets named by the keywords contained in a Column A. I am thinking this function will look something like "If Cell in Column A contains "A", copy the whole row to either an existing worksheet named "A" OR automatically generate a new worksheet "A." AND "If Cell in Column A contains "B", copy the whole row to either an existing worksheet named "B" OR automatically generate a new worksheet "B," and so-on with other elements like "C" contained in Column A. I would also like this sheet to refresh automatically, whenever someone changes the master sheet. I would also hope that the data does not become duplicated, and that the first row would be copied onto all worksheets. Any guidance you might be able to offer on this would be most appreciated.
| Sort By | Info 1 | Info 2 | Info 3 | Info 4 |
| 111 A 111 | 1 | 1 | 1 | 1 |
| 22 A 2222 | 2 | 2 | 2 | 2 |
| 33333 B 333 | 3 | 3 | 3 | 3 |
| A 444 4444 | 4 | 4 | 4 | 4 |
| 5 BB 5555 | 5 | 5 | 5 | 5 |
| 6BBBB 6666 | 6 | 6 | 6 | 6 |
| 7777B7777 | 7 | 7 | 7 | 7 |
| 88 CC8888 | 8 | 8 | 8 | 8 |
| 999 C9999 | 9 | 9 | 9 | 9 |
I would want this to look like: on three DIFFERENT worksheets, all within the same workbook. I would also like to be able to add an entry to the above table, where it would populate automatically to the below worksheets without requiring running a Macro or other type of manual refresh.
| Sort By | Info 1 | Info 2 | Info 3 | Info 4 |
| 111 A 111 | 1 | 1 | 1 | 1 |
| 22 A 2222 | 2 | 2 | 2 | 2 |
| A 444 4444 | 4 | 4 | 4 | 4 |
| | | | | |
| Sort By | Info 1 | Info 2 | Info 3 | Info 4 |
| 33333 B 333 | 3 | 3 | 3 | 3 |
| 5 BB 5555 | 5 | 5 | 5 | 5 |
| 6BBBB 6666 | 6 | 6 | 6 | 6 |
| 7777B7777 | 7 | 7 | 7 | 7 |
| | | | | |
| Sort By | Info 1 | Info 2 | Info 3 | Info 4 |
| 88 CC8888 | 8 | 8 | 8 | 8 |
| 999 C9999 | 9 | 9 | 9 | 9 |
