Is there a formula to have information transfer from one main page to multiple tabs?

Copper Contributor

I have many tabs and one main tab with all my information. 

 

Client One6/21/1210 boxes
Client Two4/2/2212 boxes
Client Three5/6/121 box
Client Four3/4/1312 boxes
Client Five4/5/1311 boxes

 

 

I have separate tabs for all clients and would like the date and box amount  to add itself to it prospective tab. Is that possible with a formula? Maybe a Vlookup and indirect? Thanks! 

3 Replies
Why not filter your main tab for the client you want to look at and get rid of the individual client tabs?
Hi Jan,

That is a good question. The main page has basic information just so I can keep track and the individual client tab has much more detailed information about the orders. So I would like to keep the client tab without having to enter information I already have on the main sheet! Thanks!
I would suggest to try the XLOOKUP function (if you are using Excel 365) or if you have an older Excel, the VLOOKUP function. You can use that function on your client sheets to look up data in the main sheet by the client's id (or name or any other unique value tied to the client).