I am looking for a formula --- to lookup a value from A1(which has a
datavalidation list of sheetnames inthe w/book) and extract data from that
sheet range A1:G1250 to current sheet. example A1=Smith
formula I want in M1=Smith!A1:G1250
If I drag fill handle of M1 all data should come to M1:S1250 range.