I have two worksheets (ws): client and collections
'Client' names exists in cell B6 and 'Date' in row range A10 until end of cell with date on "Client ws"
'Client' names also exist in row range D8 until end of cell with client_name and 'Date' in row range B10 until end of cell with date on "Collections ws"

I want a macro to do this:
1. checks if Client!B6 is equal to a cell in row Collections!D8:&...
2. checks if Collections!A10:&... equals to date in Client!B10&...
3. if both arguments are true then copy the data on row Collections!D9