Should I use VLOOKUP in multi sheet spreadsht to create a summary?

I am compiling a data summary from an annual spreadsheet that contains 1 sheet per month into summary form. The spreadsheet has approximately 5.2 million entries and I am only wanting to pull data that matches specific criteria from specific filters into columns that summarize monthly. i.e., 1st level filtering only operations & maintenance data. There are multiple columns filtered to get the specific information desired. This is a function I rarely use and have never attempted it at this level.

Thanks