Copy multiple cells to workbooks faster?

Hello,

I am trying to copy values from different worksheets and workbooks into a new worksheet. I know how to do this but it is very time consuming to type "=" then go click on each individual cell I want to copy over. Is there a way I can copy multiple values from other workbooks or worksheets at once (while maintaining their formula)? Help would be greatly appreciated! Thanks!