Thanks for the help everyone over the few days! I still have one more little query though if anyone can help me out. Lewiy has given me some code http://www.mrexcel.com/board2/viewtopic.php?p=1370688#1370688 which will cycle through my sheets and pull out some data from specific cells. Sadly I cant get it to work though. I'm trying to get the code to go through all of the sheets and pull out the info from cell A2 and pop it in cell B6 of my summary sheet and then cell A3 and pop that into C6. The thing is, because there are many sheets I will need this process to repeat filling each row from B6 down with the information from the other sheets. Help!!