Single item reporting based on multiple worksheets using visual basic

[pomporompompomp]

Hello,

Good day!
I am a newbie in the visual basic programming world in excel. My problem is my boss wants me to make an automated report of volume, capacity, etc. of different processes of different items manufactured in the company. When an item is selected, in a simple click, the program should output all the data of that item. Could you please give me a sample code on how to present an item report based on worksheets on the same workbook. Thanks!

[arthurbr]

Hi and welcome to the board
Impossible to get started without having an idea of your data layout
At first glance a simple VLOOKUP is what you need