VBA - if value met - copy numerous columns into new worksheet

[dpmaki]

I have a worksheet that is made up of columns A through BB. What I want to do is pull various columns into a new spreadsheet if one particular column equals a certain value. I don't need all columns just about 9 of them. I'd like to do this with VBA code. Can anyone help get me started on this?
The worksheet that I need to pull the data from is titled AR and column AE needs to equal US900 in order to meet my criteria.
Many thanks!