Linking one spreadsheet to another

[msama]

Hi all,

How do you link a spreadsheet in one workbook to a tab in another workbook, pass parameters and then manipulate data? I am a newbie, please help.

Thanks!