Importing data week by week

[marcidee]

Please can someone let me know the best way to approach this challenge - I need to create a Master sheet capturing data week by week during the year from another sheet each week. The issue is lining the data when the client's locations will not always be the same (income is against the location).

I have tried to show what I need to achieve below:

23/09/2018
Company	Location	Profit
Action on Hearing Loss (previously RNID)	Brondesbury Road	99.45
Action on Hearing Loss (previously RNID)	Harding House	174.38
Clarion Housing (formerly Circle Anglia/Centra)	Brentwood Foyer	338.95
Community Options	Bromley Flexible Support Service	81.83
Dimensions	27 Sampson Avenue	77.29
Dimensions	46 Juliana Close	55.29
Dimensions	Matlock Close 4	150.82

<tbody>
</tbody>

30/09/2018
Company	Location	Profit
Action on Hearing Loss (previously RNID)	Brondesbury Road	85.00
Action on Hearing Loss (previously RNID)	Brookside Drive	72.00
Clarion Housing (formerly Circle Anglia/Centra)	Brentwood Foyer	250.00
Community Options	Bromley Flexible Support Service	55.00
Diamond Resourcing	Leadenhall Market	77.00
Dimensions	27 Sampson Avenue	62.00
Dimensions	66 Titian Street	35.00
Dimensions	Matlock Close 4	88.00

<tbody>
</tbody>

Master Spreadsheet
Company	Location	Profit 23/9	Proft 30/9
Action on Hearing Loss (previously RNID)	Brondesbury Road	99.45	85.00
Action on Hearing Loss (previously RNID)	Harding House	174.38
Action on Hearing Loss (previously RNID)	Brookside Drive		72.00
Clarion Housing (formerly Circle Anglia/Centra)	Brentwood Foyer	338.95	250.00
Community Options	Bromley Flexible Support Service	81.83	55.00
Diamond Resourcing	Leadenhall Market		77.00
Dimensions	27 Sampson Avenue	77.29	62.00
Dimensions	46 Juliana Close	55.29
Dimensions	66 Titian Street		35.00
Dimensions	Matlock Close 4	150.82	88.00

<tbody>
</tbody>

 

[pharside]

The best way to do this is to use vlookup on your master. What works well is having all of your clients in column A and then using vlookup in the data columns you need. The next question is, are all your weeks on one sheet or broken down with each week having its own sheet?

 

[marcidee]

Thank you for your prompt reply - each week a new sheet will be generated with the data needing to be merged.

I have tried Vlookup with Indx/Match - the problem is I can't have all the clients on the master from the start as there will be new locations regularly added - and that's where I think there is a problem