Search multiple columns from Multiple Worksheets and copy rows into a Summary Worksheet

I am new to Macros or you could say very very rusty. I am trying to compile production for certain items over multiple weeks over multiple worksheets. I need the Macro to search columns F, J, N, R & V in all worksheets for a certain Item and then copy that info in that row into a Summary Worksheet.
The info I specifically need copied would be in the row the item was found-Column A, B & C every time and then if found in column F-need DEFG, if J-need HIJK, if N-need LMNO, if R-need PQRS, if V-TUVW.
I have attached an example of the database. I would like to be able to search by "Blue Moon" or any other item listed in the columns F, J, N, R & V.

Alan, thanks that is getting most of what I need. I do need to also copy at least column B in the same row that the item was found. Preferably I would like columns A:C in that row.
ws.Range(Cells(i, *Column A:C?*), Cells(i, j - 2), Cells(i, j + 1)).Copy

It doesn't like this line:
ws.Range(Cells(i, 1), Cells(i, 3)).Copy

So that worked at getting columns a-c copied over, but then I got a Method error for this line "ws.Range(Cells(i, j - 2), Cells(i, j + 1)).Copy" which had worked before.
Thank you for helping so far!

Run time error '1004'
Method 'Range' of object '_worksheet' failed

THANK YOU - THIS WORKS GREAT!!!

I have 1 more question - can I grab cell A1 in each copy? A1 contains the Date of each sheet.

Thank You Thank You Thank YOU!!! It works!!