Greetings,

Im having difficulties and would like to seek advice from experts in the forum. The situation is as below:

My duty right now is to create a database of material pricing and I already created multiple worksheets in one excel. Here is the problem. I wanted to use Vlookup function on one worksheet, where when I type in the detail I want, it will look up the detail in other worksheets and bring out the information. For example, i have a list of worksheets from 1 to 10. The detail I type in is on different worksheet named worksheet A. How do I can have vlookup function from multiple workbooks into 1 workbook. Maybe using VBA or any function that are available in excel?

Thank you for spending time attending my problem.