Collate data from other sheets by list selection

Hi,

Attached is a thinned out version of the actually document I am working with, names of sheets have been changed so I will need to change them back later. My knowledge around this query is limited so please be patient as I may have further questions later and I'm not sure this is even possible.

VBA CAN'T be used as this will be a shared doc using the web version of Excel

This is what I'm looking to achieve:

Users will manually enter data on their specific sheets relative to store number, they will fill out just 6 columns;
Hours Actual; Hours Target; Contract Actual; Contract Actual; Outs Training; Outs Others. No calculations nor collation on these sheets

On the Master(first) sheet I need to be able to select a week number from a drop down list in say B3 which will correspond with the week number on each store sheet and return the corresponding data, so;

If on (Master:B3) selected was week 1 this would return data on Master sheet as follows.
Sheet (Store 1) D11:I11 would fill in C7:F7 & M7:N7
Sheet (Store 2) D11:I11 would fill in C8:F8 & M8:N8
etc...

If on (Master:B3) selected was week 7 this would return data on Master sheet as follows.
Sheet (Store 1) D17:I17 would fill in C7:F7 & M7:N7
Sheet (Store 2) D17:I17 would fill in C8:F8 & M8:N8
etc...

Does that make sense?
I just would like to collate the data from sheets Store 1:Store 17 on the Master sheets relative to week selected

There is no data in the store sheets so just fill in with anything to show a working version if this is at all possible.

As I say it can't be done with VBA which I know could fix this but I think maybe INDEX; MATCH; VLOOKUP or something could get this working, maybe I need a unique list for data validation or something?

Hopefully someone can help and this is workable.

Thanks in advance
Tez

Thanks guys,

Bo_Ry, not sure how that works with selecting a week number on Master sheet B3

I have attached another example, looking at just stores 1&2, if in list Master B3 week number 7 is selected then:

Master sheet would show for store 1
C7:F7 210 220 230 240 M7:N7 60 55

If week 20 selected then
C7:F7 340 350 360 370 M7:N7 125 120

For store 2
C8:F8 220 230 240 250 M8:N8 65 60

If week 20 selected then
C8:F8 350 360 370 380 M8:N8 130 125

And so on if that makes sense. But this needs to be for all stores

@JohnTopley & @Bo_Ry

Both seem to work exactly as I needed but I'm at work right now so will check properly later

And no "guessing" needed.

As my OP said, I have limited knowledge so you have been very helpful.

Once checked later I will mark as solved if all is good

Again thanks

Now live on working document and works as needed. Managed to work out how to amend slightly as document changed in design.

@JohnTopley @Bo_Ry thanks so much for your help

For future users looking back, this is all about collating data from multiple sheets to one master sheet based on list selection on master sheet. Works on desktop version and web version

[SOLVED]