The PATools Data Copier allows you to copy data quickly and easily within Microsoft Excel between different workbooks and worksheets, including closed workbooks. This is particularly useful if you have large volumes of such data to copy.

You can also amalgamate data from multiple sheets (and workbooks) into one sheet.

You can copy values only, ranges of data, or whole sheets.