I have a worksheet I am working on. I am leaning towards the use of VBA (of which i am trying to learn) or using excel functions. In this workbook are 3 worksheets. One displays the informtion on a grid based on a vehicle number and date. Second worksheet is where the information is concerning the vehicles. It has a unique column witha job number that is not the same with each job. Third is just a collection of information based on the second workshet to get the count of items checks done.

several things i want to do with this is:

1 - Be able to pull information from a different workbook, sort the data, post into sheet 2 (jobinfo), (I do have a small macro for this, but would be open to more suggeestions)
like, would it be easier to put that information into a different sheet in same workbook, or can i reference the workbook even if it isn't open and still get the same data)
2 - If information is added to the other workbook, i want it to search for that job number on sheet2, if it isn't there then add the entire row -from column A to F.
3 - IF possible, i would like to get it to post the JOBID, based on criteria of date and truck number (This one is not a necessity but would be helpful)

Stem Compliance2.xlsx

Thanks for all the feedback in advance.