Return column contents to separate tabs based on text in heading

Hi,

I have a spreadsheet with a source tab that has columns of different types of data, each named with a text (not numerical) title at the top. I have about 10 different categories of data appearing randomly, and which I was hoping to sort into different tabs. I was hoping to create a tab for each separate type of data (each heading), and have a formula to automatically retrieve all of the relevant columns from the source tab.

I thought about having some sort of HLOOKUP function in each tab, and if it identified the columns, I could perhaps then use the offset function to copy across the actual column contents (offsetting one cell at a time from the top of the column). I am not an expert, but I was thinking of this sort of approach to keep it simple, so that I would only need an array formula once for each column, just to identify the appropriate columns, then the individual cells could be filled by a simpler formula.

I am not certain that this would be the best approach though, so I thought that I would ask for advice.

The example spreadsheet shows just two column categories (cash and stock). Thank you very much in advance.