Break out excel file into individual sub files based on checked boxes

Hello Alive05 and Welcome to Excel Forum.
I am going to make a few suggestions.
1) While it is possible to use check boxes, this tutorial shows how (section heading "How to link a checkbox to a cell"), I think that it would be easier to use an "x".
2) It will make things easier to put the entire grocery list on one sheet. Sheets have 1,048,576 rows so I think there should be room.
3) Put each person's shopping list of a separate sheet in the same workbook as opposed to putting them in separate workbooks.
The attached file gives you an idea of how this would work.
On the Groceries sheet Kevin's and Sarah's choices are marked.
On Kevin's sheet (Sarah's sheet is similar) the following array entered formula* get the shopping list items:

Formula:

Please Login or Register  to view this content.

*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.