Import data as value to a master sheet

[DavidLabonte]

Good Evening,

I am looking for help. I am with an organization and we need to track our hours (5 different categories) as well as total KMs per month.

What we have - Each user (12 for now) has a workbook with 1 tab per month, and 1 total.

What we need - 1 macro per month (Jan, Feb, Mar...) to import the value of each individual and their respective hours and kms.

Essentially:

Workbook: 'Person 1'
Sheet: JAN
Cell: F51

Value copied to (and saved independently from previous workbook) to:

Workbook: 'Master'
Sheet: JAN
Cell: D13

This needs to be copied to 4 more 'hours' per person, and 1 KM entry.

If you could point me in the right direction that would be awesome!!

Thanks!