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

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)

any one pls

Thanks for response..

ur code work actuall what i want..
but last two row (Row no 31 & 32 ) in masterdatasheet file remove when we apply this code..
this 2 row is main calcuated row..

thankyou so much we got valuable help

Hi Jmac1947 actually we pm sixthsence yesterday & i remind him today also .... we think may bhi he not consider my pm... so i pm with u... ur advice i remember in future... to send PM forum expert... we hope next time when we face problem u also help me thanks..

Add this Macro to place a drop box in cell L1 with a list of file names.

Please Login or Register  to view this content.

hello Sixthsense & mehmetcik
sorry once again we start this tread for one more change..

with help we almost near complete to my work qucikly with macro..

now we want one more thing in above sheet

if we press Y in cell g32

then copy range a35 to g35 row data in rate list sheet..

my file is attach

thanks in advance