I Month column and revenue from different products

I filter for January and Want the sum of revenue for this range to be pasted in cell A3 of the next workbook

Eg January 20031
6548
25165
65465
54654
68444
This whole revenue should be summed and pasted in a cell in the next workbook

I need a code for this