[SOLVED] Formula auto pick up the data from corresponding tab

[jackson_hollon]

Hello,

I have a file that has few worksheets. I need a formula to auto pick up the data from the correct tab based on the date on a cell. I have attached a worksheet here. Hop it makes sense to you.
Thanks a lot for the help.

Jackson
Test.JPG

[FlameRetired]

This is one way.

Please Login or Register  to view this content.

[jackson_hollon]

Hi Dave,

Thanks for the response. I used the formula and it works perfectly.

Thanks for the help.

Jackson

[FlameRetired]

You're welcome. Thanks for the feedback.

[azumi]

wrong post, self deleted