matching in vba

[bisetti]

I have no idea if there is a way to do this or not. What I want to do is:

I have one file, A that has no info. I have another file, B and file B contains many sheets. I would like to run a macro in file A that will look at each sheet in file B and if it finds today's date, then copy the row which contains this information to file A. There will be maybe 4-5 entries in file B with today's date, so when it pastes the info into file A it will need to go to the next row to paste so it is not pasting on top of itself 4 or 5 times. Is this possible?

Thanks

 

[Cbrine]

Are all the worksheet in workbook B formated in the exact same way? If so, what column is the date stored in?

Cal

 

[bisetti]

yes they are all formated the same way. Dates are in B.