Import data from Closed Workbooks

Hello

H had a similar thread but the position here is different

I have four workbooks in the same folder
One named (ODI) this is where I want to import data as values ..
All what I want to do to import data from other adjacent workbooks (Record01 - Record02- Record03) from sheet named with the same name in these workbooks named (Data).

The range to be copied from (Data) sheet from A1:L & LastRow

Another impotant point :::
I want to exclude some rows depending on a condition .. My condition is Column L has "From" text .. If the cells say L14="From" this row is to be excluded from copying.
Or this can be done by deleting rows which contains this text after copying data
Here's an attachment

Mr. JBeaucaire
Perfect Solution and awesome code
Just one last point >> paste data as values

Originally Posted by YasserKhalil

Mr. JBeaucaire
Perfect Solution and awesome code
Just one last point >> paste data as values

Please the last point in this code

Thanks for your reply Mr. JBeaucaire
The problem of the code is that it destroys the formats prepared in the WB "ODI"
I think this is because of deleting the rows ..

Another point There are three messages during executing the code
(There is a large mount of information on the clipboard ....)

I already do the change .. Thanks for getting rid of these messages
But still destroys the formats of the worksheet

Can you modify the code so as not to delete the rows which contains the word "From"?
I think it will be easy for me to use another code to do that without using filte and deleting rows

Thanks for these valuable information
Now it is almost to be done
Just want to start data at A1 without deleting Row A as I have dynamic ranges which is related to row A
This will be the last request Mr. JBeaucaire
Thank you very much for your patience

Mr. JBeaucaire
I'm sorry for making you change alot .. I don't expect the code will destroy my dynamic ranges > The results are not expected for me.
You provide me with your wonderful codes and I try them and see the results ... If anything or any error appears I inform you !!
Generally I'm satisfied of the results until now .. I can change my dynamic ranges so as to start A2 instead of A1

Yes I tried it and everthing is OK except this empty blank row!!
But we can stop at this point . I'm satisfied with the results

I marked the thread as solved ..
But if you can help me getting rid of the first empty row without destroying dynamic ranges I will be very grateful for you.. even if after some time ..