Are you saying that you have four seperate worksheets? I'm really not following you. If you have four spreadsheets, you can use four seperate OLE source transformations and use a Merge or Merge Join transformation to bring these all together. The write out to a single OLE destination.

I have a feeling I'm not understanding the whole issue,

Rob