Linking a Sheet to a Report?

I need to be able to cell link between a Report (where I have pulled data from dozen of projects) into a Sheet (that I am using for adding other data fields that will be manually udpated) but....the data is in the Report and I need to link it INTO the Sheet (I can do it the other way around but not from the the report into the sheet). When I am in the Sheet and try to link to other files it will only allow me to link to anouther Sheet - no reports appear in the folder structure to link to. Is this me being stupid or is there a way to make this magic happen that I am missing? Thanks.