You need VBA macro code. Lots of people have the same request. I need more
details to help. You need tell me more information.

1) Are all the excel files in one directory or organized some other way?
2) Do you want get data from all workbooks in the directory or files with
cetain names?
3) What is the name of the worksheeet(s) you want to copy data from?
4) Do you want entire rows copied orjust some columns
5) What is the name of the detination worksheet(s) in the master workbook.
6) How do we identify the last row(s) of data that needs to be copied. Your
request says that you copy multiple rows. How many rows.

"MGC" wrote:

I am working with 30+ workbooks which contain timesheets (tabs) for every day
a job is worked in our plant. I have inserted rows at the bottom of the
timesheets which will gather the information from the timesheet above so that
this information can then be moved to the first blank row in a master sheet
in another workbook. I'm thinking there has to be an easier way than copying
and pasting the data each time. The number of lines to be moved will vary
from day to day. If anyone can help, it would be much appreciated!