I currently have two workbooks in which I need to have data from one
transfered to the other. One workbook contains many sheets and I need to
look in 4 sheets to find the information that I need. The workbook that I
need the data transferred to also has many sheets, but for the year we are
currently in, I only use one sheet.

How can I grab the data from the first workbook and transfer it in the
correct columns to the 2nd workbook.

Thanks in advance for any help you may be able to provide.
--
DMM