Hi Rennie I have one problem please help me solving I have multiple excel work books in a folder each work book have one work sheet each worksheet consists of worked hours daywise these info is from D8 to H8. I need to copy it to new excel sheet from all selected work book can help me with any macro