Can I do a form type query/report in regular excel?

[Guitarmageddon]

Ok, so I got some help in another post on consolidating data. Now I have something thats a bit more complex that I have no clue how to do. Im fairly certain it can be done with access or Power BI, but Im not good with access at all, and I currently dont have access to Power BI.

I have two giant source tables. They are queries into my workbook from two separate excel files I had to clean.

They produce a table that looks like this (some more columns over to the right of course)

and like this

What Im trying to do is basically create a query in another sheet, where staff from a given store (columns A and C, respectively for example), can go into this sheet, type their store number or maybe select from a dropdown, and then it provides them a clean output on one tab, of their specific data. For example, it would look like this in my mind. Store types 01100 in cell d1, then the query generates the below.

What is the best way to make this happen?

 

[Guitarmageddon]

Ok so an update to my lengthy post above.... i decided to dust off the cobwebs in access to get something workable. It seems to be working relatively well. However, I have to do some research now on how to basically append two reports I guess? Thats what I would need in order to create an output example like I showed above. I created a dropdown list that a store can select their store number, but I produce a report onto two different access tabs. Is it possible to output two different reports on one tab?