Hi I am trying to get the data in a group of cells from 1 worksheet to a single cell in another worksheet in the same workbook. I have tried CONCATENATE but that only works on a single sheet. Basically, I need to copy the components from a daily sheet into a summary sheet but don't want to have multiple lines on the summary as each line refers to a date. I have attached an example. Thanks for any help.