Generating summary calculations from multiple worksheets within the same workbook

Hello, I have attached a dummy file to illustrate my point exactly, but I'll try my best to briefly describe what I'm trying to do.

I have multiple worksheets in one workbook, all of the same format (i.e. data located in same cells consistently). On the "Summary" worksheet I'd like to compile a summary list of data with each row representing data picked from each worksheet in the book.

I'm just now familiarizing myself with vb syntax, but I'm thinking an if-statement like the following example may be able to cycle through the worksheets and add data row by row on the summary table:

Please Login or Register  to view this content.

However, this code is obviously incomplete, and this would only report values from other worksheets and not make calculations. I'm trying to accomplish 2 things:

1) The "fish" and "mix" data are sometimes flipped on 2 different rows in different sheets, as seen in the dummy file. The script would need to check to see which row contains the "fish" data and "mix" data and report them in the appropriate summary columns.
2) I'm trying to do more than simply report the values - I need to do some simple calculations with some of the values, while only reporting the values in others. You can the calculation formulas I'm trying to do in the example summary table on the Summary sheet in the workbook.


Any help would be appreciated, and thanks in advance, guys!

It's been a week or so since you replied, WorldBridge, and I'm just now getting around to reviewing the code. This is a huge help. I added rep for you as well, thnks so much!!!!