Vlookup (or something!) to return multiple results?

I've been thrown a bit of a curveball at work and am trying to work out ways around it.

Basically I have a front sheet in my workbook that displays each individual on a separate line (this is fed from a Master spreadsheet). I also have 4 other sheets for different category of issue - say A-D. If an individual is linked to a category A issue there is a link on the front sheet that takes you to the relevant cell in the Category A worksheet. An individual may have one or more of each category to his/her name.

The front sheet has to contain only one line per individual (otherwise this would be easy).

What my colleague wants to be able to do is to have a further sheet with each individual's name on it, with each of the Category instances listed next to that name, so this sheet would have to pull data from the 4 Category sheets and collate them next to the correct individual ID so that all the items and the total costs can be seen.

I hope that all makes sense.

My gut feeling is that this is just not possible in Excel, at least with my limited knowledge (I'm only just learning VBA by myself)

Does anyone have any ideas how I might go about this, or how the spreadsheet could be restructured to facilitate this more easily?

Thanks in advance once more

Mads

if you upload a sample file that closely resembles real-life data, it may expedite things for all concerned...

So... like a table, where the first column is each person by row, second column is "category A" filled with data looked up from tab_A, third is "category B" with data looked up from tab_B, etc?

Yeah, I agree this would be easier with sample... maybe you could layout and title how you want the output organized for us???