I have data that is stored on one workbook that entails information from
different shifts. ie. days1,2, swings 1, and graves 1, 2. The info is
organized by date and each shift in columns under each shift.

What I need to do is to copy all the information just for each shift into a
new worksheet. The worksheets are identical. I need to separate out each
shifts information and was wondering what is the easiest way to do it. I've
tried linking each column, but it won't do multiple columns since they are
spaced out. PLEASE HELP!!!