Hello,
I have a file with 4 different tabs some of which have the same headers but others have different headers. I'm looking for a formula that can consolidate on 1 summary tab without having to use Power Query (system issues not allowing it to work properly). I'd also like the summary tab to reference the tab name from which the data comes from. I've attached a sample worksheet showing the end goal. I've tried using aggregate formulas but I'm not able to get it to work. I'm open to a vba as well but formula would be best.
Thanks!!
Bookmarks