How can I copy data from one workbook and create another workbook?

i would like to know how can i copy data from one workbook and paste it into another workbook. Note - 'Another workbook' contains a specific format in which data should be pasted and the first workbook is humongous source of data ,so i should be able to go to a specific tab ,unhide hidden columns,apply date filters,remove the data not needed and then paste the remaining fields and data in second workbook

Even after 4 hours this is all i am able to do(no coding experience,never wrote a code before,this is my first time ) ,but this code sucks(user specific/machine specific) ,it worked 3-4 times and now it has stopped working. Please help ,please help, PLEASE HELP!

Please Login or Register  to view this content.
Workbook - review Dates tab.pngReview Dates Tab - Date Filter - Tomorrow.pngSpecified format for the data.png