Need a draggable formula to fill in 53 weeks

[Twiggy199]

I'm very new to this so bare with me, I need to use numbers so double bare with me...

Week #	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12	Week 13	Week 14	Week 15	Week 16	Week 17	Week 18	Week 19	Week 20	Week 21	Week 22	Week 23	Week 24	Week 25	Week 26	Week 27	Week 28	Week 29	Week 30	Week 31	Week 32	Week 33	Week 34	Week 35	Week 36	Week 37	Week 38	Week 39	Week 40	Week 41	Week 42	Week 43	Week 44	Week 45	Week 46	Week 47	Week 48	Week 49	Week 50	Week 51	Week 52	Week 53
Store Weekly Revenue
Orders placed
Over/Underspend	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

So what I need is a draggable formula that I can put in B2 from the table above that will pull the data from B16 in the table below, I have 53 sheets all with tables named the same as the sheet and i just need a formula that wont require me to manually input x=x for every cell.

Task​	Monday​	Tuesday ​	Wednesday​	Thursday ​	Friday​	Saturday​	Sunday​	Manager Reviewed​
Store Revenue​	£1000.00​							FALSE​
Shop Front Clean, Tidy & Restocked​								FALSE​
Backroom(s)/Toilets Clean & Tidy​								FALSE​
Trello Jobs Completed​								FALSE​
Cashing Up/Banking Tracker​								FALSE​
Cleaning Rota Signed​								FALSE​
Stock Checks​								FALSE​
Stock Ordered​								FALSE​
Stock Received via courier​								FALSE​
Stock Received On VEND​								FALSE​
Store: External Clean​								FALSE​
Cash Banked​								FALSE​
Bin Collection Day​								FALSE​
Miscellaneous​								FALSE​
Store Weekly Revenue​	£1000.00​		Average Sale​			Transaction Count​
Top-up Order Value​
IQOS Order Value​
Main Order Value​	£500.00​					Items Sold​
Spent on Main Order​

Sorry, this didn't appear how I thought it would so just for ease of use, B16 is the cross section of Monday & Store Weekly Revenue.

If I'm unclear in what I'm saying please just scald me.

 

[Twiggy199]

Ok, how about

=INDIRECT(B1&"::B16")

Thank you so much, that did the trick, thank you for being so patient with me!

 

[Fluff]

You're welcome & thanks for the feedback.