Extract data in multiple columns from multiple worksheet

[p4ngp4ng]

Hello!

I'm having a hard time making formula for my reports.
Can someone help me please!!

I am working in logs industry, I have workbook with multiple worksheets, the other worksheet name PJan-PDec it means that was the logs we receive every month, and another LJan-LDec for the logs we used for the production. The only same value that the two have was the Logs Number. I need the data of which Logs Number I enter, but the problem was, I only need the specific column in that different worksheet.

Your help was very much appreciated.
Thank you!

 

[alansidman]

We need more information. What data do you want from which workbooks? In what column is the log number in each workbook. What column of data do you wish to extract for the particular log in each workbook. Please provide details of what you are trying to do. Your explanation is very vague and no solution can be provided based upon what you have provided.

 

[p4ngp4ng]

Thank you for your response!

for example:
these are the names for every sheet
PJan PFeb PMarch-PDec - logs we received every month
continued sheet
LJan LFeb LMarch-LDec - logs we used for production from the logs we received.

in all sheets (PJan-PDec) have the same column name
Date-Logs Number-Species-Length-D1-D2-D3-D4 (D stands for Diameter)-Calculation-Average-Hollow-Volume in M3

and all sheets with (LJan-LDec)
Logs Number-Specie-Length-Diameter-Volume in M3-Condition-New Length-New Diameter-Defect Volume-New Volume in M3

in Master sheet which I name LogsUsage.April (or what month) I want to get The data from PJan-PDec, Species-Length-Average Diameter-Volume in M3 and the Data from LJan-LDec, Condition-New Length-New Diameter-Defect Volume-New Volume...this data should be extract whenever I input Logs Number in column B

And if it is ever possible, the Master sheet(LogsUsage.April) when i copy this sheet will also run for new month ex. (LogsUsage.May)

Thank you!

 

[p4ngp4ng]

Please let me know if I need to add more data to make formula for my reports.

Your help is very much apprecited.Thank you! ?