...copy and paste cells/data from 3+ workbooks into one?

[Andasolo]

I want to copy and paste certain cells from different workbooks and organize them in one workbook on three (or however many worksheets there were originally - tabs) -is there a way to do this quickly without copying and pasting each one?

The 3 workbooks will have data changing but the tabs will remain constant and have the same worksheet name. The range for data is different in each sheet however...

Ultimately I want to import/copy the data from those three different sheets/workbooks into a new workbook and three different tabs.

Thanks in advance for any input.