I need to create a macro that extracts daily files data to a mont.
 

I got a project that, requires to consolidate daily activity for multiple
locatons files (who contains two tables and titles inside a sheet ) into a
monthly report. I have been trying with convetional formulas but, there is a
"Protection" issue and a possibility to looking foward some good macro to
resolve this situation.

Regards,
Juan