WHAT-IF Copy & Paste Function

Hey everyone,

This is my first question on this forum and something I've been trying to figure out for quite some time now. My knowledge of excel is not as extensive as a lot of you on this forum, so I looked at this as an opportunity to learn from you all.
Pardon me if I don't explain this question that well.

I have a Grocery Pricing Sheet document with 6 sheets: Kroger, Sam's Club, Walmart, Costco, Liquor Barn, and Grocery List. I currently have a WHAT-IF function set across all sheets where if I add an X in the Buying? column, then it will take the Price from the Price Column of each item with an X and total them. This gives me an idea of how much I will spend on groceries during any given shopping trip so I can budget accordingly.

What I want to do is create a WHAT-IF function that will copy the Merge Brand/Item Column text from any given sheet and paste/itemize that text on the Grocery List Sheet. That way I have an easier view of what I need to purchase.

Below is an image attachment to clarify on this idea. I also attached my excel sheet if that helps at all.

Image
Attachment 331812

Excel Document
Grocery Pricing Sheet.xlsx

Mrice, thank you!! It works great!