Hi I want to get information from one sheet to another I think it would be some kind of index match but have been unable to find a solution

I have a data sheet (DS) that is populated with the Excel stock function,
This gives a mix of data running horizontally and vertically Horizontal is the ticker symbol and vertically below them in two columns are the dates and prices.

On another sheet there is a test Portfolio(PS), I have a table that corresponded to the stocks.

What I would like to do is populate the PS sheet from the DS sheet see attached photo - is there a way to do this ? Thanks
Fund Inception.jpg