Combining two excel reports into one spreadsheet

[luv4ball37]

I have two reports that I have exported from our system into excel. One report contains data that I need to include in the other. I was told to use the Index function however I can not get it to work. Is there anyone that can help me?

 

[PCL]

We need more details about the data layout: where data is coming from each file, where and how to merge information ?