Need to Copy and Paste a specific range, according to Header and Row

[joao1232]

I have a workbook that has two worksheets. The first worksheet, called "CotasFundos", is the source file, where the data is to be copied from. The worksheet "Cota", is where the data will be copied to. In "CotasFundos", there are four headers (there could be more though if i wanted to add more). The first column header is "Data", followed by "Carteira 1" then "Carteira 2" then "Carteira 3". Also, in column A, there is a list of dates. However, when you go to other worksheet, the list of dates begins at an earlier year, so i cant just copy and paste normally because the dates would not match. I need to be able to find the exact row where the first data in "CotasFundos" matches with the date in "Cota". There also needs to be a match with the columns "Data", "Carteira 1", "Carteira 2" and "Carteira 3".

How can i do this? Thanks in advance