Lookup from various sheets from the workbook

[naveed2010]

Work book has more than 10 sheets(sheet2,sheet3.........) with values with similar headers.... from A column to Z column.
In each sheet column B has the unique references & column O has another references, with numeric, alpha or alpha numeric.
.
In same work book will have one MainSheet to have the lookup of references...
Vlookup VBA should work with below conditions.

If I write the reference in A3 of Main Sheet (unique reference) (or) other reference in A4 & by writing the concern sheet name (sheet3, sheet4) in A5
Related valued rows to be pulled from the specific sheet and to be showed in MainSheet.
Note: Values to be pulled based either by Unique reference & Sheet name (or) otherreference & Sheet name.
Kindly share the VBA code where the details comes based on above input.

 

[AlanSidman]

crosspost: Split data from Single Sheet to Various Sheets and specific row to be picked and displayed (excelforum.com)

 

[vletm]

naveed2010
Please reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.