Which of these solutions is faster: "="+cell, vlookup, index/match

Hello all,

Short question from me.

I have to import column B from approx. 800 excel workbooks. In column A of each workbook there is a list of data (some starting from 2009, others from 2015, others from 2020 ...) and I will have to import the data starting with 01.01.2022.
Unfortunately, I don't have the resources to import them with PowerQuery (Excel tells me it ran out of memory), so I'll have to import them using one of the following methods:
- simple "=" + cell
- vlookup
- index / match

I'm curious which solution consumes the least resources.
Also, if you have any other suggestions, I'm open

Thank you.

It depends on the starting date on column A. Usually between 4000-5000 rows and counting.

In terms of memory, we work with 32-bit Office and I understand that this is where the problem could come from ...

This is what I was talking about:
https://docs.microsoft.com/en-us/off...ition-of-excel

I receive exactly the same error message.
Anyway we will upgrade to Office 360 this year, so everything should be fine (I think), but until then =+cell it is )

Thank you.