Dropdown to link other sheet and lookup data for last cells

[Thuch Vannarath]

Hi everyone, I am Vannarath. I have one question need you all to help me. I have 4 sheets from sheet1 to sheet3, I typed code date and quantity which the code has 5 columns. In sheet 4 I have defined dropdown in I2 Cell(yellow fill) which has all code fromsheet1 to sheet3. So my purpose is that in sheet 4 I want to select code in I2 cell then it will appear in code column date and quantity automatically for the last cell of date and quantity. Note: I'm looking only the last cells when I select the code in dropdown. I'm looking for your answer. Thank in advance!

[hoyasaxa215]

Can you reorganize the data or rename the sheets? Is there any reason the data from sheets 1-3 can't be consolidated onto one sheet? If not, can the sheets be renamed to reflect the list number? For example, Sheet 1 would be renamed '62011'.

[Thuch Vannarath]

I don't want all data in one sheet, but the sheet can be renamed as you mentioned above. Could you help me?

[hoyasaxa215]

Please see attached. Respond if this is inadequate or if you have any questions.

[Thuch Vannarath]

Thank you so much. It works great.

[Thuch Vannarath]

I need the code columns to show also in sheet4

[Thuch Vannarath]

Are they any formulas?