Need to get another data sheet table contain by refering sheet2 C3 cell name

[harsha_manjula]

Hi

This is my first post. hope at the intial stage i can get better solution from this forum.

Here is my issue.

I HAVE WORK BOOK CALL "Nook1Table"
I need to get data from datasheet when I select name from sheet2 C3 cell.

Attached my excel also for more your reference.

Thanks & Regards,
Harsha Manjula Premarathne