what do you mean with "data is variable": the format, or text data, numeric data..
Give us some details please. DAta are in other sheets in the same workbook? or in other workbooks?