Something like this, for example?:

=IF('full_path[filename2.xls]Sheet1'!
A1<"",'full_path[filename2.xls]Sheet1'!
A1,IF('full_path[filename2.xls]Sheet2'!
A1<"",'full_path[filename2.xls]Sheet2'!
A1,IF('full_path[filename2.xls]Sheet3'!
A1<"",'full_path[filename2.xls]Sheet3'!
A1,'full_path[filename2.xls]Sheet4'!A1)))

Put this in your "one" cell, and it will bring data from A1 of either
Sheet1, Sheet2, Sheet3 or Sheet4 of filename2.xls, whichever is not
blank.

Hope this helps.

Pete

On Aug 28, 3:38*pm, Shek5150
wrote:
Greetings...

I would like to know if there is a way to link a single cell from one work
sheet to several cells from another worksheet (from a different workbook).. *
Kind of like a one-to-many relationship; however, on the many side, only one
of the several cells in this second workbook would have data at a time *and
it would be this data that would migrate to my main workbook on the "One"
side of the relationship.

Hope that mades sense...

v/r,

Steve