VBA Code - Transfer data to worksheet based on user entered list

[senior chow]

Hi, I have a spreadsheet set up with 2 tabs.

"Data" This tab includes a cost report with lots of rows and columns. It include job numbers in column A
"Input" This will be for users to enter job numbers in 2 different lists. One in column A and one in Column B

Im looking for all the data from the data tab to be split and transfered into 2 new worksheets based on which column it was entered in on the input tab.

Thanks in advance.