Hello, I am fairly new to using VBA code and Excel Macros, and I was wondering if anyone has any recommendations on the following problem:

I compile an Excel workbook (Workbook 1) with data that is emailed to me from several Excel workbooks (Workbook A, Workbook B, etc.). As of now, I manually copy and paste values this data from each workbook that is emailed to me into my workbook.

1) I would like to create macros that will enable me to automatically copy a select range of data from each workbook (Workbook A, Workbook B, etc) that is emailed to me and paste values the data into specific ranges within specific worksheets in my workbook (Workbook 1) that I use to compile all of this information.

If anyone has any suggestions for the above, that will make my life much simpler. Furthermore, if possible I would like to expand on the ability to copy/paste from one workbook to another for the following:

2) I would like to copy several ranges of data from several worksheets in a workbook that is emailed to me and past values the different ranges of data into different worksheets in my workbook all in one macro.

Any help or advice is much appreciated.