Using Multiable sheets for Invertry Control

I am trying to do what "ctrl f" does with more info available using the query list , as ctrl f does not allow expansion of headers , if query could do the same I could save a lot of time updating sheets,
I explored Access however the history i need at a glance is more suited to excel and a sheet per item .
any thoughts or suggestions appreciated.