I need to copy data from various workbooks into one master file, specific data

Hi all,
I have to run a macro at work, a consolidated file that includes data which another user has input, which means i need to specify the cell reference for the data i want to copy. However the problem is each file will have different cell references. How do i do this? I am new to macros, so Please be patient with me..

Thanks in advance for your help. Any ideas to solve to problem will be much appreciated.

OK could you upload a sample (non-sensitive?)

Hard to upload those files as they contain confidential details..
Basically there is a shared drive, where another department updates data on 10 different workbooks, each workbook contains one worksheet, where data is being added every week. My task is to pick up the data that is being added every week into various workbooks and consolidate into one master file. Does that make sense?

Thanks for responding promptly

It does, but with no actual structure it is hard to give any meaningful help.

1. Are the particular cell references always remain the same for each worksheet (workbook)?
if so, you could write a reference table (to be used by the macro)

Workbook name Worksheet Name input column output column

where the output column is the column you want in your master sheet.

2. Does the data consolidated into the master sheet deleted after it is posted?
if not, I would suggest to mark it as posted (in the original worksheet)

3. Record your actions in the master sheet
It would give you an idea to write the VBA code