Macro to copy rows of data based on a value supplied

I have attached a simple workbook which I would like to copy rows of data that matches my search criteria to another workbook. For example, in column A, I would like to copy all the rows of data to a new workbook any row with "SK". Or I may want to copy rows of data that MB is chosen in column A. This could be simply by entering SK in a certain cell or a userform. Thanks for the base as the actual spreadsheet has many more rows and columns, but all I need is the basics and I can build from there!