RedFive wrote:
I have about 20 sheets in one workbook and I'm trying to pull 1 column from
each sheet and put that info into it's own sheet. Right now i'm trying to
import into access and build querries but I'm running into errors, not sure
if I've run out of columns or if it's some other kind of error.

Are you trying to sum the data from the 20 sheets into a single sheet?

gls858