Hi Xor this is exactly what I was after and thanks for educating me re name manager. As this works what is the best way for me to get the live data in - should I save as and add in the real data in the data sheet? I obviously do not want to mess with the formulas. One additional question is there an easy way to incrementally add the days to the merged data in cells 09-EE9 so that Monday follows Tuesday etc without having to manually copy and paste? thanks for all your help thus far - really appreciated