VBA for display Various Datasheet data in Masterdatasheet when we choose datasheet name

[santosh226001]

Hello Experts & Forum Guru's

We work in a Work book with Various sheet.. in this workbook A master sheet (masterdatasheet) & many other datasheet (Each sheet with diff data)

We want a VBA for my master sheet with a Combo box or list type data validation.. where we choose Sheets Name ......... after choosing datasheet... those sheet data Dispaly in My Master data sheet....

with MasterdataSheet we are caclucating some calculation which is which is sown in bottom line in this sheet

My Sample file is attached with 2 datasheet.. (in my original sheet more then 50 sheets so we enclosed only 2 sheet for trail baisis)

Thanks in advance

(My Hiden sheets protection password is san19241 or san if u want help with those files)