Ok. I"m going to try and re-explain this. I haven't gotten much help so far and not familiar w/ the programming aspect of Excel. Anyways, here we go.

1. I have 31 identical sheets in a workbook representing Days of the month.
2. Each cell is filled w/ the same type of data but not value.
3. I would like to take all the data and put into ONE master sheet.
4. However, I only want to copy the cells that contains data and leave the blank cells alone.

For example, cells B5:M5 are temperatures. I would like to take ALL filled in cells from B5:M5 and copy to another worksheet. If the cell is blank or doesn't contain a numeric value I would like to skip it. Therefore, I can do my bias calculations from the compiled dataset on the new worksheet.

Hope this is better explained. This is only for temperatures so I will be doing this for many other parameters. Thanks for your help.

Jason