I several woorkbooks in an excel Spreadsheet.

On one woorkbook I have a listing of stock transaction called trades which
could comprise of twenty different stocks.\

On another workbook I would like to sum the profit/loss of each stock.
I need to filter the stocks out of the trades workbook by symbol so I can
calculate profit/loss on each individual stock over a period of time.