--------------------------------------------------------------------------------

Hi, can anyone out there please help me to solve this?

I have created many different excel workbooks (each with multiple worksheets) which help me to analyse different scenarios. These workbooks are linked in some way. (e.g. the input values in workbook 1 are linked to that in workbook 2, workbook 3 and so on. Sometimes the output values of workbook 1 become the input values of certain worksheets in workbook 2 etc). I find it tedious to keep track of all these input and output values - which is linked to which.

So, I am thinking of creating one single sheet, where I can enter ALL my input values, instruct the respective workbooks to extract their own relevant data from this sheet and return ALL the output values on the SAME sheet. Is it possible? How?

Thanks!