macro select specific (but same) cells from multiple worksheets and export to 1 sheet

  • Hi,


    I am trying to export values from the same four cells (B3, AF4, AF4, and JJ2) from multiple worksheets into one master sheet with four columns (all B3 values make one column, all AF4 values make the second column, and so on) in the same workbook. The first sheet is named 'Master' and is empty. This is where I want the macro to export the values and create the four columns. The remaining ~70 sheets/tabs in this workbook contains the names of different people (in the format last name, first name) and has information pertaining to each individual. However, I want specific information for each person and want to combine it all into the four columns. What macro can I use?


    Thanks,
    Pinky.